RE: RPG embeded SQL insert statement

Good tip.  I suppose that the new V5R2 dimensioned data structure would 
work as well, wouldn't it?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2003 04:10 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: RPG embeded SQL insert statement


I'm not sure about the opening and closing on insert statements.  You can
however, block the insert much the way you would using the OVRDBF command.

The insert statement would look something like this:
C/exec sql 
C+ insert into FILEB  (field1, field2)  xxx rows values(multiple 
occurrence
DS name) 
C/end-exec 

Replace xxx with the number of occurrences of the DS.

Rick


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.