Re: RE: SQL RPG - How to Use INSERT?

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Thank you very much!

rpg400-l@midrange.com writes:
>Cursors are used for reading through the table/file.  Insert simply adds a
>row/record.  Example of an Insert below:
>
>C/EXEC SQL
>C+ INSERT INTO EGR0110P
>C+       (SITE,
>C+        PINBR,
>C+        PITR,
>C+        CINBR,
>C+        CITR,
>C+        CIDESC,
>C+        CIDRAW,
>C+        QTYPR)
>C+ VALUES('MFG',
>C+        :Parent,
>C+        :ParentRevision,
>C+        :Component,
>C+        :CompRevision,
>C+        :CompDesc,
>C+        :CompDrawingNo,
>C+        :Quantity)
>C/END-EXEC
>
>Hope this helps!



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com