Re: Reset SQL schema to *LIBL

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Thanks for the reminder on the *SQL vs *SYS, Rob.  I was already taking 
that into consideration, but it didn't click with me that just using 
DEFAULT would return me back to *LIBL.  I kept trying different ways to 
specify *LIBL (e.g., %LIBL, %LIBL%, etc.).  But yes, the simple solution 
of DEFAULT worked exactly as I needed.

On 6/24/2019 8:30 AM, Rob Berendt wrote:
> A lot of that depends on whether or not you are using system naming or sql naming.  With system naming the initial default is *LIBL.  With SQL naming the initial default is the default library of the user.  Why this is important is trying to change it back from whatever you changed it to (which is what you are asking).
> If you are using system naming you could execute the following to change it back to *LIBL.
> SET CURRENT SCHEMA = DEFAULT
>
> I changed my STRSQL from *SQL to *SYS naming.  Then I verified the above with:
> values current schema
> set schema = 'ROB'
> values current schema
> set schema = default
> values current schema
>
> https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/db2/rbafzsetschema.htm
>
> See also:
> RUNSQLSTM ... NAMING(*SYS)
>
> Embedded
> https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/db2/rbafzsoption.htm
> See SET OPTION NAMING above
>
> Rob Berendt