Using environment varaible in the job paramter
Posted: Wed May 21, 2008 3:08 am
Using DRS stage to read from oracle database table, in the sql the from clause is a job paramter. In the job paramter I have a environment varaible, and the job aborts saying invalid character, can we use a environment varaible in the job parameter?
Here is the Job Paramter
#FromClause# = prdtbl where #$LoadType# =1
Here is how the SQL looks when we use SQL generated option
SELECT ABC FROM #FromClause#
The error is
DB: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00911: invalid character
: SQLExecDirect: Error executing statement
'SELECT ABC FROM prdtbl where #$LoadType# =1'
Is it because the entire sql is in between ' ' and it is being considered as a string, if so is there a workaround for this?
Thanks,
Here is the Job Paramter
#FromClause# = prdtbl where #$LoadType# =1
Here is how the SQL looks when we use SQL generated option
SELECT ABC FROM #FromClause#
The error is
DB: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00911: invalid character
: SQLExecDirect: Error executing statement
'SELECT ABC FROM prdtbl where #$LoadType# =1'
Is it because the entire sql is in between ' ' and it is being considered as a string, if so is there a workaround for this?
Thanks,