RE: RPG embeded SQL insert statement

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

Rob,

I don't think so.  I tried it when V5R2 first came out and had trouble
getting the program to compile.  The pre-compiler kept hiccupping on the DIM
keyword.  I didn't have a lot of time so I reverted to what I knew worked.
Sure would be nice if we could use DIM though.

Rick

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Tuesday, May 06, 2003 5:02 PM
To: Midrange Systems Technical Discussion
Subject: 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.


_______________________________________________
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.