topic Re: Connections between SAS and Netezza in SAS Enterprise Guide

Connections between SAS and Netezza

OGA — Wed, 28 Apr 2021 12:57:25 GMT

Hello,

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

LinusH — Wed, 28 Apr 2021 13:06:09 GMT

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 — Thu, 29 Apr 2021 05:34:56 GMT

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 — Fri, 30 Apr 2021 04:55:21 GMT

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

libname LIBREF clear;

OGA — Fri, 30 Apr 2021 10:42:28 GMT

Hello,

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

thanks