Hi

I need to update the field IBGLPT in table F4102 from the F4101 field IMGLPT for only the records where F4101 IMITM = F4102 IBITM

This is the statement that I put together:

UPDATE TESTDTA.F4102
SET TESTDTA.F4102.IBGLPT= ( SELECT TESTDTA.F4101.IMITM
                FROM TESTDTA.F4101
                WHERE TESTDTA.F4101.IMITM=TESTDTA.F4102.IBITM)
WHERE EXISTS
        (SELECT TESTDTA.F4101
    FROM F4101
    WHERE TESTDTA.F4101.IMITM=TESTDTA.F4102.IBITM);

I get an error; Arithmetic overflow error for type varchar, value = 721220.000000.

Any help is greatly appreciated

Thank you

Post your column data type for the tables. It may be that your are trying to insert varchar data into and intr column or the other way around.

both colums, F4102 (IBGLPT) and F4101 (IMGLPT) are char, 4, NUll is flaged. Thanks

Hi,

You can very well see the length you have defined for the column and the value you are inserting.

You will have to increase the size of your column.

Thanks,

Lalit
Life Means More...;)