Hi,
I am facing an issue in IBM DataStage when passing a full SQL query as a Job Parameter.
I have a job parameter that contains an entire SQL query with single-quoted literals (for example, string or date values).
This parameter is then directly used in a stage (for example, as the Select statement).
However, when the job runs, the single quotes are missing in the actual SQL that gets executed.
which causes SQL errors or incorrect results.
It appears that DataStage is stripping or altering single quotes during job parameter evaluation or substitution.
I would like to understand:
Why single quotes are removed when a SQL query is passed as a job parameter and What is the recommended or supported approach to pass a full SQL query with quoted values as a parameter in DataStage?