odbc stage update netezza table issue
Posted: Tue May 06, 2014 1:41 pm
Hi,
I have issue with odbc stage upating the netezza table.
Query:
UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ORCHESTRATE.FILE_ID_IN
Passing below values to the odbc stage
RUNDATE = '9999-01-01'
FILE_ID_IN = ('asdf','zxcv')
issue is with the ORCHESTRATE.FILE_ID_IN
when i hard code the value for FILE_ID_IN in the query then job ran fine
UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ('asdf','zxcv')
please advise how to reslove this.
I have issue with odbc stage upating the netezza table.
Query:
UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ORCHESTRATE.FILE_ID_IN
Passing below values to the odbc stage
RUNDATE = '9999-01-01'
FILE_ID_IN = ('asdf','zxcv')
issue is with the ORCHESTRATE.FILE_ID_IN
when i hard code the value for FILE_ID_IN in the query then job ran fine
UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ('asdf','zxcv')
please advise how to reslove this.