odbc stage update netezza table issue

[hsahay]

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.