Skip to Content
avatar image
Former Member

While sending data to DB2 tables, SAP PI JDBC is adding '&apos' character instead of '(single quote)

Hi Experts,

we have MDM --> PI --> DB2 scenario, while inserting the records into DB2 tables using JDBC channel, SAP PI is adding ''' character instead of '(single quote).because of this field length is getting increased and DB2 is throwing below error

"DB2 SQL Length Error: SQLCODE=-433, SQLSTATE=22001".

Question: How to suppress ''' before sending data to DB2 table to resolve the column length issue without increasing the column length at DB side.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 20, 2017 at 11:28 AM

    Hi Ravindra,

    I used to replace that in a java mapping. There is an example below.

    https://wiki.scn.sap.com/wiki/display/XI/SAP+PI+-+Deciphering+apostrophes+in+XML

    Regards,

    Andrzej

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 03:26 PM

    Hi Ravindra,

    Have you tried with SQL_DML notation?:

    https://help.sap.com/saphelp_nwpi71/helpdata/en/44/7b7855fde93673e10000000a114a6b/frameset.htm

    Regards.

    Add comment
    10|10000 characters needed characters exceeded