Re: Run SQL Scripts (iNav) and Library List

[Jeff Young <cooljeff913@xxxxxxxxx>]

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