DSXchange

Can you post the full, unedited message please? Are there any other warning/error messages logged along with it?

Does it work if you perform the same steps locally?

Run it both ways, let us know.

You can't check the sql code with this design because all you'll see is the reason why the second action, the update failed... 1403... and we don't care. You need to perform strictly the insert so you can determine why it is failing.

It's not that it is appending it, it is important to realize that the stage returns the results in a (possibly multi-entry) dynamic array, so if you literally just use the entire result you'll get at least one field mark delimiter. That's why discussions here mention two methods to deal with that: T...

I believe you would use rsh for this as well.

There was no need to convert anything to an integer, as Ray noted in your first reply, your issue was the inclusion of the @FM 'Field Mark' by the Execute Command stage. This needed to be stripped in order to be passed successfully which a search for your 'is not appropriate' error message would hav...

OK... what other messages were logged? What did you mean by you 'fixed the ds_login'? You'll probably need to post your dsjob syntax as well, otherwise we're all just guessing.

Zero isn't an error but rather an indication of success. Did your Sequence job actually run? If not, what other messages were logged?

Seems to me the first thing to determine is why the inserts are failing. That should be some form of constraint violation - unique index, check constraint, foreign key constraint, etc. And there is a way to do inserts only with that stage, though from what I remember it is a little counter-intuitive...

Seems to be a pretty common problem and a quick google for 'communication link failure' only brings up results for SQL Server.

These kind of things are generally network related.

And how is that a 'workaround'? Sure sounds resolved to me.

Jobs with a transformer are the only jobs that require a C++ compiler to 'compile' in DataStage, everything else is generating OSH scripts. Configuring the C++ compiler can be problematical regardless of version, you've got to make sure you have a supported compiler (the documentation will specify w...

devesh_ssingh wrote:i have run the job its compiling but get aborted after.

What does this mean? You can compile a job with a transformer but it aborts when you try to run it? Regardless, describe the job design.

In case anyone hasn't seen the previous conversation on this topic and wants to know how we got here:

viewtopic.php?t=130698