Error while using netezza enterprise stage(nzload)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ujala
Participant
Posts: 45
Joined: Mon Jun 21, 2010 2:51 pm
Location: Chennai

Error while using netezza enterprise stage(nzload)

Post by ujala »

Hi all,
I am using Datastage 8.7,platform -windows
I am loading data from dataset to netezza using netezza enterprise stage(nz load),

Data gets inserted but the job aborts due to following error:
Error: Error occured while opening data file
Error: Load Failed, records not inserted.

I have browsed to some of the blogs and it says its fixed in datastage 8.1 and 8.5 but i am not sure what is causing problem in datstage 8.7

Jobs works fine if i use netezza connector stage
(Tested in different environment but the same problem persists)

Adding to it i am even able to read data from netezza enterprise stage

Help me out to resolve this error!
Post Reply