Update a column condidionally

Arun Raj · Posted: Thu Nov 22, 2007 6:47 pm

Hi
I have a DB2 table . I want to update a column based on the value of a working-storage variable.

ie. If ws-var = "A", Set column = 'B'
else Set column = 'C'

Can I do this within a single update?..

Thanks,
Arun

Srihari Gonugunta · Posted: Fri Nov 23, 2007 9:37 am

Handle this in your program
IF WS-VAR='A'
WS-COL='B'
ELSE
WS-COL='C'
ENDIF
and always update the table with value from WS-COL. So you will end up with single update statement.

Arun Raj · Posted: Fri Nov 23, 2007 1:22 pm

Hi,

Thanks for your reply. I am doing in that way only...

Thanks,
Arun