Skip to Content

JDBC Receiver: How to put values into single quotes

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers