Skip to Content
0

JDBC Receiver: How to put values into single quotes

Oct 27, 2016 at 11:51 AM

76

avatar image

Hi All,

I am working on JDBC Receiver (PI 7.31) and have to create an insert statement with values enclosed in single quotes.

I have tried to place single quotes in the mapping using concat, but they get removed in SQL statement generated by Receiver Channel

I have also tried to use hasQuote = "yes" or hasQuote = "no" but no use.

The apostrophe escape character has been set to '' (2 single single quotes).

All these have not worked. Need your suggestions

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

0 Answers