Error Message :
Incorrect syntax near ','.
U02004025 Job-script execution was aborted.
In SQL JOBS, SQL queries containing multiple lines and thus the carriage returns work.
However, when a multi-line query is fed to the SQL JOBS via
a variable through a VARA EXEC or SCRI object the query fails.
This is the situation in which the SQL JOB fails:
- The process tab of the SQL JOBS only contains a variable (&SQL_QUERY#)
- A VARA EXEC or SCRI defines the variable &SQL_QUERY# and calls the SQL JOBS (as an executable object or with ACTIVATE_UC_OBJECT respectively)
- The variable contains a multi-line the SQL query