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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.