Updating a DB2 table by a cobol program

DEEPAKNAG · New User Joined: 12 Aug 2005 Posts: 1

Hi all,

Can any one pls tell ne what will be the query for

updating a DB2 table by a cobol program.

i want a generalised format.

pls help me

regards
Deepaknag.y

bonniem · New User Joined: 09 Aug 2005 Posts: 67

You should have searched for this.

UPDATE <table name>
SET <fieldname1> = <value1>, <fieldname2> = <value2>
WHERE
<conditions>

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

hi frnd,
hope the below query will do
EXEC SQL
UPDATE SET ENAME = :ENAME
WHERE ENO = :ENO
END-EXEC.