DSXchange

Hi

I am using OracleEnt stage , user defined sql

select max(RUN_ID) from schema.Table_Name

Error executing View Data command:##E IIS-DSEE-TOPK-00007 06:43:51(012) <_PEEK_IDENT_> Input dataset does not have field: "RUN_ID".

Target is sequential file (name of the stageMax_Run)

datastage director error is below

Max_Run: Error when checking operator: Could not find input field "RUN_ID"

some one can advise me please

Thanks
Srini

Please check the columns list in your source file.

select max(RUN_ID) as RUN_ID from schema.Table_Name