AW: SQLRPGLE

Hi Dave,

if you are already on release V5R3M0, you may check the following syntax:

C/EXEC SQL
C+ Update MyTable
C+    Set Row = :MyRecordDS
C+ Where .....
C/End-Exec

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars." 
(Les Brown) 

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Dave
Reiher/prairiefarms
Gesendet: Mittwoch, 15. Februar 2006 16:57
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQLRPGLE



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