To expand slightly, SET DEFINE OFF is a SQL*Plus command. I don’t know of any easy way to get those to work inside DS. There are a variety of other solutions to this problem, though. You can use concats to single out the ampersands, escape them, use an ASCII value, etc.
The reason why I am asking this is because ‘&’ is a part of one of the values in the IN statement in the WHERE clause of the query.
for e.g. we have the query whose WHERE clause reads as
STRING in (‘ABC’,‘XYZ’,‘P&Q’,‘DEF’).
When the DEFINE variable is ON, and we don’t give a value, or give a dummy value, ‘P&Q’ data isn’t being retrieved by the query.
The actual statement can’t be posted in this forum because of confidentiality issues.
Our WHERE clause is a bit complex, and had to be used in a SQL transform.