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

[Former Member]

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.

[iaki_vila]

Hi Ravindra,

Have you tried with SQL_DML notation?:

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

Regards.

[Andrzej_Filusz]

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