Re: Run SQL Scripts (iNav) and Library List

Thanks Scott.
That fixed it.

 
Jeff Young
Sr. Programmer Analyst






________________________________
From: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Wed, June 8, 2011 1:46:20 PM
Subject: Re: Run SQL Scripts (iNav) and Library List

hi Jeff,

In my setup, I have:

On the Server tab:
  SQL default Library = *LIBL
  Library List = (left blank)

On the Format tab:
  Naming convention = *SYS

That seems to use the library list successfully for me.  It sounds like
you have set your SQL default library to an actual library name instead
of the special value *LIBL, which might be the problem for you?

Good luck


On 6/8/2011 12:03 PM, Jeff Young wrote:

V6R1
In the JDBC Setup, in the Server Section, I specify a library name for the SQL
Default Library, and a list of file libraries in the library list section
separated by commas.
In the Format section, I specify System (*SYS) as the Naming Convention.

After I connect to the system, whenever I attempt to run any command that has
an
unqualified file name, I get a message indicating that the file is not
found.  The file that I am using is in the Default Library and my library

list.

Is there any way to get it to use the library list I specified to find the
file?

Thanks,

Jeff Young
Sr. Programmer Analyst