Re: Reset SQL schema to *LIBL

Hi, Joe,

I could not find this documented anywhere,  but in STRSQL, this seems to do what you want:

    set current_schema = DEFAULT


Don't ask how I stumbled upon that ... just experimenting in STRSQL ... ;-)

Hope that helps,

Mark S. Waterbury

On Monday, June 24, 2019, 9:05:45 AM EDT, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx> wrote:
In STRSQL, VALUES CURRENT_SCHEMA returns *LIBL.  I can change that to
something specific using SET CURRENT_SCHEMA, but is there a way to get
it back to *LIBL?  It's actually not as important in STRSQL as it is in
things like RUNSQLSTM or in an embedded SQL program.  I'd like to be
able to temporarily override my schema for something specific, and then
return it to *LIBL when I'm done.

This is one of those edge places where IBM i and DB2 don't quite mesh
intuitively for me.