Connections between SAS and Netezza

[OGA]

Hello,

we have problems with the connections between SAS and Netezza, they stay open after the query is finished.

[LinusH]

Connections are generally open untill the session ends.

Are the queries issued through libref or Proc SQL CONNECT TO?

Have you used the CONNECTION= option?

[OGA]

Hello,

We use libref

Send a proc sql. P.E

proc sql;
SELECT max(ci5301_periodo) format best. INTO :fec FROM Rdb2CI.ci5301;
quit;

[SASKiwi]

In that case just clear your LIBREF once your query has finished:

libname LIBREF clear;

[OGA]

Hello,

I found the problem, we have auto-assignable Netezza libraries. When users disconnect incorrectly, the connections are not released.

thanks