RE: SQL Issues

["Dane Cox" <DCox@xxxxxxxxxxxxx>]

That did it.  I can see them again through Ops Nav.  I missed this in
the Redbook but it's right there on page 106 of the 'Stored Procedures
and Triggers on DB2 Universal Database for iSeries'.  Thanks!!!

Okay, so now how do I get data into a cursor without doing a select from
a database file?  I'd like to be able to either 'insert' directly into
the cursor one record at a time, or better yet, put an entire array into
the cursor.  It doesn't appear to be possible...or am I just not reading
the other Redbook closely enough?  :-)

Any ideas would be greatly appreciated!!

Thanks in advance,
Dane

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Parkins
Sent: Wednesday, June 16, 2004 3:32 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: SQL Issues

Try MODIFIES SQL DATA instead of CONTAINS SQL.

Brian Parkins
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




NOTICE: This electronic mail message and any files transmitted with it are 
intended exclusively for the individual or entity to which it is addressed. The 
message, together with any attachment, may contain confidential and/or 
privileged information. Any unauthorized review, use, printing, saving, 
copying, disclosure or distribution is strictly prohibited. If you have 
received this message in error, please immediately advise the sender by reply 
email and delete all copies.