Re: Should I be using SQL?

["David Turnidge" <daveturnidge@xxxxxxxxx>]

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