DSXchange

Hi,

I am trying to update a table with 9 columns and I get the warning message "buffer overflow" and ofcourse the table is updated. I have similar jobs that does update on other tables but I do not get this warning message. Can someone help.

UPDATE ODS_CUSTOMER SET
CUST_CASID=:2,USERID_MODIFIED=:3,UCN_ULT_CREDIT_PARENT=:4, UCN_CUSTOMER=:5,ULT_CREDIT_PARENT_CASID=:6,
CUST_COUNTRY_CODE_DOMICILE=:7,CUST_COUNTRY_CODE_NATIONALITY=:8,
CUST_CURRENT_OBLIGOR_GRADE=:9,NAICS_CODE_6=:10
WHERE CUST_KEY=:1

Thanks ,

You would have to give some more information.

Usually the warning you see is that you're trying to insert data of a wrong type in a column. E.g. inserting a non-numeric value in an INTEGER column.

Ogmios

You can have this warning if you try to insert too much of data in a column, like a string of 15 chars in a column typed varchar(10).

You can also get this message if the total number of characters in a row exceeds the limit set in uvodbc.config. By default this limit is 8K, but can be changed via the MAXROWBUFF parameter in this file.