[CLOSED] Global Variable in DBMS SQL flow in Datamigrator
Hai
using DMC gen 833, release 81M Because of a rather complicated query, I am using a DBMS SQL flow. As part of the query I coded this DB2 Common Table Expression:
DAG (DAG_KEY) AS (SELECT DAG_KEY FROM GWSDDBA5.GWTB403 WHERE DAT = '2010-09-09')
This is accepted and works fine. But when I replace the date field with a global variable
DAG (DAG_KEY) AS (SELECT DAG_KEY FROM GWSDDBA5.GWTB403 WHERE DAT = '&&WV_VRWRKDAT_DT.EVAL')`
I get an error message saying: Cannot parse DBMS SQL