DSXchange

hey,
guess what i found....
when i use the updte action as "Delete existing rows only". the job executes successfully. but any other update action forces the job to abort horribly.
why is that?

Guyz,
The problem lied in metadata mismatch. Thanks for your help Kcbland. You sure directed me in the right direction. From the sql server, the key was set to bigint. when i changed that to integer within datastage, the job executed fine.
The target table still has bigint, but it executed fine.
Now thats another question huh?
No seriously, thanks once again.

Guyz,
The problem lied in metadata mismatch. Thanks for your help Kcbland. You sure directed me in the right direction. From the sql server, the key was set to bigint. when i changed that to integer within datastage, the job executed fine.
The target table still has bigint, but it executed fine.
Now thats another question huh?
No seriously, thanks once again.

Hence the bind issue, trying to stuff one datatype into a non-supported value for the driver. Well, sometimes the last shot is the one that works. We knew the SQL was the issue, just the datatypes when the connection is made and the SQL prepared was the issue.

Don't worry about the datatype inconsistencies between your job and the actual table. Just put an Annotation on the job so that metadata tweak isn't lost or forgotten if the metadata is ever reloaded.

I will do that. Thanks once again.