Search found 47 matches
- Fri Oct 10, 2008 6:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No row was found for FETCH, UPDATE or DELETE; or the result
- Replies: 5
- Views: 8225
The table contains very much real production data. So, i cant insert any dummy records :cry: The job is as well scheduled in CTRL-M and i am running the job through scripts in unix. I have coded the script like,if it encounters one fatal error the job will be abended. Is compressing the message in t...
- Wed Oct 08, 2008 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No row was found for FETCH, UPDATE or DELETE; or the result
- Replies: 5
- Views: 8225
No row was found for FETCH, UPDATE or DELETE; or the result
My datastage job will delete the records which are older than 60 months in the table. The job is running fine if there is some data older than 60 months. But when there is no data older than 60 months it is giving me a fatal error : Error in row #1 Primary Error: sqlcode=100, state=HY000, message=[I...