First, I'm a newbie here and forgive me if I'm on the wrong section of forum to posts my question. My concern is I am following a sample DB2UTIL usage on to update a db2 table using sas data set, sample is as follow:
proc db2util data=trans table=testid.employees function=u;
With this example, the empno is a NUM datatype which where able to process the requests when I tests it. But when I try to add quotes on empno values (e.g. 321783 to '321783') to make it CHAR datatype (of course my table is also a CHAR datatype accordingly for this field), when I execute and test the result, it is now can't read correctly the value %empno. Below is the actual log I received:
UPDATE testid.employees SET phone = '3999' WHERE empid='
DB2 SQL Error, sqlca->sqlcode=100
DSNT404I SQLCODE = 100, NOT FOUND: ROW NOT FOUND FOR FETCH, UPDATE,
OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE
UTIL Function: U
UTIL LIMITS - COMMIT: 1000 LIMIT: 0 ERROR: 0
SQL calls attempted: 1
SQL calls failed: 1
SQL calls successful: 0
Kindly help with my concern.