BookmarkSubscribeRSS Feed
OGA
Fluorite | Level 6 OGA
Fluorite | Level 6

Hello,

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

4 REPLIES 4
LinusH
Tourmaline | Level 20

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?

Data never sleeps
OGA
Fluorite | Level 6 OGA
Fluorite | Level 6
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
PROC Star

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

libname LIBREF clear;
OGA
Fluorite | Level 6 OGA
Fluorite | Level 6

Hello,

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

 

thanks

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1235 views
  • 0 likes
  • 3 in conversation