I have a prog that should update all KY cust master records with the new code AR.
I run the program but nothing happens. The file remains unchanged.
I am new to embedded sql so what am I doing wrong ??
D OLDWH S 2 INZ('KY') D NEWWH S 2 INZ('AR') * Get all records with 'KY' C/EXEC SQL C+ UPDATE TRNLIB/CMP C+ SET CMWH = :NEWWH C+ WHERE CMWH = :OLDWH C/END-EXEC C EVAL *INLR = '1'
December 14, 2009 2:55 PM
December 15, 2009 1:34 AM