Skip to Content
0

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

Mar 20, 2017 at 10:41 AM

44

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Andrzej Filusz Mar 20, 2017 at 11:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Iñaki Vila Mar 20, 2017 at 03:26 PM
0

Hi Ravindra,

Have you tried with SQL_DML notation?:

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

Regards.

Share
10 |10000 characters needed characters left characters exceeded