I am needing to update this field in this table
BOTTASK - field ASVALUE - with example ( Adj_0129 ).

ENGINE DB2 SET DEFAULT_CONNECTION DB2T
-SET &DATE01 = AYMD(&YYMD, +0,'I8YYMD');
-SET &Date02 = EDIT(&DATE01, '$$$$9999');
-SET &T_ASVALUE = 'Adj_' | &Date02 | '.xls';
-*******************************************
SQL DB2 PREPARE SQLOUT FOR
UPDATE BOTTASK
SET ASVALUE = 'Adj_0129.xls'
WHERE TASKID EQ 'T127j5rvdr01';
END

It does not give many error so then I do a print on the
record and it has not changed...

TABLE FILE BOTTASK
PRINT
TASKID
ASVALUE
WHERE TASKID EQ 'T127j5rvdr01';

Is there something I am missing?


Don R

This message has been edited. Last edited by: Don Robison,

Don, a shot in the dark... maybe your webfocus user is not authorized for update on the db?

We figured it out.

SET SQLENGINE=DB2
SQL DB2 END SESSION;
SQL DB2 SET SERVER DB2T;
-SET &DATE01 = AYMD(&YYMD, +0,'I8YYMD');
-SET &Date02 = EDIT(&DATE01, '$$$$9999');
-SET &T_ASVALUE = 'Adj_' | &Date02 | '.xls';
-*******************************************
SQL DB2
UPDATE BOTTASK
SET ASVALUE = '&T_ASVALUE'
WHERE TASKID = 'T127j5rvdr01';
END
-RUN

I know you got it solved, but.....

how about using modify?
substitute your values in the

MODIFY FILE BOTTASK
FREEFORM TASKID PACKETID ASVALUE
MATCH TASKID PACKETID
ON MATCH UPDATE ASVALUE
ON NOMATCH REJECT
DATA
,,,$
END