Re: RDi 9.5.0.3 Run SQL Scripts requires lib qualifier?

On 26-Apr-2016 12:54 -0500, Buck Calabro wrote:

On 4/26/2016 12:53 PM, Charles Wilt wrote:

You need the JDBC settings in Run SQL Scripts to be set to
naming=*SYS.

That's the only way to use the LIBL to find unqualified tables.

Completely agree.

With naming=*SQL, unqualified tables are implicitly qualified with
your user ID. Thus it looks for the file in MKOESTER.

Almost completely agree. If I do:

set schema production;
select * from masterfile;

I will get results from the table in the PRODUCTION library. This
works fine is all of the interesting tables are in the same library.
If the tables are in multiple libraries, NAMING *SYS is the only sane
way to handle that.

FWiW, the following [effectively identical] statements can be very telling; e.g. in the OP's situation, before any optional use of SET SCHEMA:

VALUES(CURRENT_SCHEMA)

SELECT CURRENT_SCHEMA FROM SYSIBM.SYSDUMMY1

If ever the result is *LIBL, then tellingly, the NAMING option must be *SYS.