odbc update error

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
abhay10
Participant
Posts: 31
Joined: Tue Nov 20, 2007 11:39 pm
Location: Bangalore

odbc update error

Post by abhay10 »

Hi,

i am getting the the error saying [ could not connect to data source] [network error] when i am trying to upadte or upsert on any tables.
the same job was working fine previously from the past few days its giving the above error

The job works fine if i only insert the data to the tables.and all the data source configaration is proper ( as i am able to view the data )


its givig error only on update or upsert options please suggest some solution to it
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

What database are you writing to? What has changed in the system since the point in time where this worked?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

If you have a network error you have to get the network error fixed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”