Quotes question - JDBC and AS400
Hello everybody, I got a question for you about quotes in string types.
I'm trying to send data from my R3 to DB2 in AS400 and when the XI creates the SQL statement to insert the data it requires that each string is enclosed between quotes, otherwise an error will occur.
In the mapper I only assign directly the source field to the target field without any operation and this way my string won't be enclosed between quotes, my question is, Is there a way to do the same operation but getting in the target field the string between quotes?
I tried with patterns and got what I was looking for, but I'm looking for a solution that applies to all strings where I only do it once and forget it for ever.