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
Error when checking operator: Could not find input field
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
-
- Participant
- Posts: 7
- Joined: Sun Apr 10, 2011 11:30 am
- Location: Delhi
Re: Error when checking operator: Could not find input field
Please check the columns list in your source file.
Re: Error when checking operator: Could not find input field
select max(RUN_ID) as RUN_ID from schema.Table_Name