BookmarkSubscribeRSS Feed
gxmessier
Calcite | Level 5

Any suggestions on this topic as we are limited to 12 connections per user?


4 REPLIES 4
jakarman
Barite | Level 11

Review all settings specific for sas/access netezza.

The shared read only should help a lot. The Libname options must be carefully set think also on SQL trace settings.

The eguide SQL query builder looks fine with sas datasets. With external dbms systems there are lot of bad behavior I als.

The SQL Pass trough setting is working but not tailored to all native sql dialects. Enough pitfalls...

---->-- ja karman --<-----
gxmessier
Calcite | Level 5

Problem with be fixed in EG version 6.1 from what I understand.

jakarman
Barite | Level 11

I am sorry to disagree gxmessier.  That kind of an answer is well known to be common to gain time, often with no fix at all.

Of you have got this answer from somebody you are not taken seriously.


If is about connect errors, That is part of  SAS/ACCESS® Interface to Netezza. Saskiwi  link is having mentioned that.

Eguide query builder is even having more problems.
Either is must use implicit SQL pass thru trusting the ANSI SQL translating to native SQL lingo's or it must do solving the native SQL lingo's in a explicit pass thru.

This problem is a very challenging once knowing how all those SQL lingo's are different. For the moment you can expect the most easy SQL's will work but as soon something more as trivial is done some weird bad behavior can occur. As SAS is rather old it can be even caused by once smart approached built in that in this newer versions are causing problems (cursor management into to DBMS).

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1284 views
  • 6 likes
  • 3 in conversation