Re: Reset SQL schema to *LIBL

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Thanks, Mark!  Yes, that's exactly what I was looking for, and like you, 
I didn't find any documentation for it.  But at least I know now thanks 
to you and Rob.  :)

On 6/24/2019 8:41 AM, Mark Waterbury wrote:
>   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.