× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2008

Re: iNam - Run SQL Script Library List

Not sure why your library list in the JDBC setup isn't working, but... you can type a command like this:

CL: ADDLIBLE HUMANRES *LAST

The CL: prefix tells iNav that it's a CL command, it it'll run it as a CL command -- in this case, it'll add a library named HUMANRES to the library list.

Subsequent SQL statements will then take advantage of the library list (in *SYS naming, anyway).



Jeff Young wrote:
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.