Re: Should I be using SQL?

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