|
Not too long ago I've had to start accessing a PC database via RPG embedded SQL. Works great. Now, in one program I want to SQL that database and the native database. (Program is compiled using the SQL Naming convention since that's what it needs for the PC database.) If life were simple, I could qualify the library on the iSeries files, but unfortunately it isn't simple. I want it to look in the library list for the file. It won't let me qualify it as *libl (e.g. *libl.filename). I also tried setting the Schema to *LIBL, but it complained about that. The FAQ says that if I have files in multiple libraries, I must qualify them. Is there no way to qualify *libl? http://faq.midrange.com/index.pl?_recurse=1&file=25#file_587 Kurt Anderson Application Developer Highsmith Inc. W5527 State Road 106, P.O. Box 800 Fort Atkinson, WI 53538-0800 TEL (920) 563-9571 FAX (920) 563-7395 EMAIL kjanderson@xxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
