Re: Disassociate a preassigned libref

ksocki · Posted 03-14-2023 07:11 AM

Hello! Is it possible to disassociate a libref that was preassigned? And do it in a stored process?
Cheers!

LinusH · Posted 03-14-2023 07:56 AM

I haven't found any specific information about this, but it would make sense if this is possible only in session scope.

Have you tried?

And...why?

Data never sleeps

ksocki · Posted 03-14-2023 08:39 AM

Hello LinusH,

we have limited oracle sessions count in one of the environments, thus we need to reduce the number of oracle librefs. This is why we try to disassociate some of them.

What do you mean by session scope? I know that it's possible to assign and clear the libname in a single session, but we have the librefs preassigned, unfortuntelly.

Regards!

LinusH · Posted 03-14-2023 09:03 AM

https://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html

Data never sleeps

yabwon · Posted 03-14-2023 08:43 AM

Won't just this:

libname LIB clear;

in autoexec in EG do the thing?

In SAS EG project tree add a program named "autoexec" and insert that line there.

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation

ksocki · Posted 03-14-2023 08:56 AM

Thanks yabwon!

We haven't tried this but wouldn't it be the same as "libname x clear" in stp code?

Still it's worth a shot 😉 I'll get back.

ksocki · Posted 03-14-2023 09:12 AM

Fail 😞

The warning is the same as in the open code: "libref was not declared in this scope"

Regards! 🙂

Disassociate a preassigned libref