Disassociate a preassigned libref

[ksocki]

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

[LinusH]

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?

[ksocki]

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]

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

[yabwon]

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

[ksocki]

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]

Fail 😞

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

Regards! 🙂