SQLRPGLE

[Dave Reiher/prairiefarms <DReiher@xxxxxxxxxxxxxxxx>]

I want to do an update in my sqlrpgle program, much like the insert I am
doing right now.
In this code below I use the data structure named FIELDOUT to write the
record when I insert.

Csr   InsertRec     begsr
C/exec sql
C+ INSERT INTO COMP_ORDER VALUES : fieldout
C/end-exec
Csr                 endsr

I know if I were in SQL I would just do
UPDATE TABLEA
SET COLUMN1 = 'SOMETHING'
WHERE KEY = THISONE

Not sure how to do it and still use my data structure, can I?
Or do I have to do something like this?
SET COLUMN1 = FIELDOUT_1
SET COLUMN2 = FIELDOUT_2
ETC. ETC.


    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx