Error inserting record into DB2 RRS feed

  • Question

  • Hi All,

    I created an insert schema for a DB2 table using the adapter wizard, the table has 160 columns, when trying to insert a record into DB2 if the number of columns being inserted is less than 50 the insert succeeds, but when trying to insert all 160 columns with values the insert fails with this error -  Invalid string or buffer length. SQLSTATE: HY090, SQLCODE: 80.

    Anyone else encounter this error before, seems like there is a character limit to the number of characters you can include in the insert message, please help.

    Regards, Pa445

    Wednesday, December 16, 2020 5:07 PM