RE: Run SQL Scripts (iNav) and Library List

Thank you! What a cool thing to know!

Paul Therrien
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Thursday, June 09, 2011 12:10 AM
To: 'Midrange Systems Technical Discussion'
Subject: AW: Run SQL Scripts (iNav) and Library List

It is also possible to set and change your library list other than changing
the default settings within JDBC setup, because it is possible to execute CL
commands (even with prompting them). You simply have to preceed the CL
command with CL: and end the command with a semi colon (;)

CL: ADDLIBLE LIB(HAUSER) POSITION(*AFTER QTEMP);

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jeff Young
Gesendet: Wednesday, 08. June 2011 19:03
An: midrange-l@xxxxxxxxxxxx
Betreff: Run SQL Scripts (iNav) and Library List

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