MVSFORUMS.com

[agredell]

DB2 V7 on Z/OS, we built UDF's to migrate between a long part number and a short part number as needed. The UDF's are working fine, converting away happily in any SELECT statement.

But, due to a program bug, some long values were stored in the short value column. As this is in a test system, I coded up a SQL statement to update where the long value is equal to the short value, to wit:

UPDATE MYDB.RESTRCTN SET RSTN_PART_NUMSHORT = MYDB.ITEML2S(RSTN_PART_NUMSHORT) WHERE RSTN_PART_NUMSHORT = RSTN_PART_NUM_LONG

DB2 complains using sql code -433; and the manual says of the "expression" in the assigment clause of the SET statement that "It must not include a column function. "

This seems most mysterious to me! I wonder how I can get my columns corrected, does anyone have any ideas?
_________________
Alan Gredell

[kolusu]

agredell,

Probably a length error.

what is the length of the column RSTN_PART_NUMSHORT in MYDB.RESTRCTN table?
what is the length of the column RSTN_PART_NUMSHORT in MYDB.ITEML2S table?

I am guessing that the RSTN_PART_NUMSHORT in MYDB.ITEML2S table has a length greater than the column you are trying to update. Using SUBSTR to just extract the length of the colum in updating table.

Kolusu