Thank you for this... I'm trying to learn SQL and have a question...

You define "MyLib" and "MyFile", however you declare C1 selecting
"System_Table_Schema" as "library", and System_Table_Name" as "file", from
qsys2/systables....

Then you open C1. The you Fetch C1 int :MyLib, :MyFile. What is the
relationship between MyLib and System_Table_Schema???

Thank you,

Dave

On Fri, Mar 21, 2008 at 12:06 PM, <rob@xxxxxxxxx> wrote:

General rule of thumb: If you are doing it using OPNQRYF you should be
using imbedded SQL instead.

Here's a generic V5R3 compatible version:

D MyLib s 10a
D MyFile s 10a


C/EXEC SQL
C+ Declare C1 cursor for
C+ Select System_Table_Schema as library,
C+ System_Table_Name as file
C+ from qsys2/systables
C/END-EXEC

C/EXEC SQL
C+ Open C1
C/END-EXEC

C/EXEC SQL
C+ Fetch C1 into :MyLib, :MyFile
C/END-EXEC




This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].