RE: iNam - Run SQL Script Library List

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

I have a 6.1 version of iNav and it works for me. Here are relevant JDBC
Settings:

1) on System tab (no longer Server I guess) I have:
2) 'SQL default schema:' =  'Use library list of server job'   /* this must
mean *LIBL */
3) 'Schema list:' = myLib1, myLib2

When I then take a look at runtime JDBC Properties, it lists the "libraries"
property as '*LIBL, myLib1, myLib2'.

Hth, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: iNam - Run SQL Script Library List

In the JDBC Setup window, under the Server Tab, I have set my library list
for the connection I am using.
I set a Default Library, Library List ocntaining the names of the libraries
containing my data files (including my default library), under the Format
Tab, I have set the Naming Convention to System(*SYS).
When I execute an SQL statement, if I do not qualify my files, I get a file
not found error.

I am using INav for Windows Version 5 Release 4.
The system I am connecting to is running OS/400 V5 R3.
My PC is running Windows Vista for Business.

Thanks,
 
Jeff Young