DSXchange

I am trying to use special characters for column names in Oracle Enterprise stage, and I get errors. I have set DS_ENABLE_RESERVED_CHAR_CONVERT to true using administrator, and have imported the metadata for a table, but I don't see the internal column names. I believe _036_ is substituted for $. In...

OK, here's the solution that I came up with. In the parallel job described earlier, instead of writing to a peek stage, the return code (-1 for failure, 0 for success) is written to a text file only if the return code is less than 0. In a sequencer the text file is interrogated for word count using ...

I am looking into the use of DSGetLinkInfo

I created an output link from the stppx stage which gave me the ability to capture the return code from the stored procedure, (set to -1 in the sp if it fails). I can now do one of 2 things. I can configure a transform having the output link of the sttpx stage as its input, and an output link to a p...

One other thing, how would one capture a return code from the sp? If the return code is set to -1, and if it can be captured by the sp stage (how?), then the next step would be to make the job fail if the return code is -1 (how?)

Thanks
Anil

It's SQL Server.

Thanks

I just changed the stored proc and raised an exception.

The Datastage job does not capture the error. It still finished status OK, while the the stored proc when executed independently aborted and raised the error.

Any ideas? Do I have to set up the custom error feature (and how?)

I don't raise an exception in the proc, but I am not sure how to configure the stp stage to capture it if I did. I have seen the custom error definition tab, but I am not sure how to define it.

Any description will be helpful.

Thanks

Hello,

I am executing a stored procedure using a stored proc stage. The stored procedure fails (for example while inserting a duplicate primary key value), yet the DataStage job finishes with an OK status. How can I make the DS job finish with an abort status?

Thanks
AL

I have a sort stage in a job to sort incoming data by column A, then B and then C. The receiving stage is a remove duplicates stage where the job picks up the last row. It removes all duplicates with the same values of A and B, except the last row, which happens to be the last value of C within the ...

Does any one know what this error means, or what may have caused it? This occurred while importing dsx objects frrom one environement to another. Line 126560: Mapping failed to find or create the target instance: JobDefn -> DSJobDef (EObject: c2e76d84.43058877.61935f.123c4e5f08b.1129f80.873f0, JobDe...

That's what I thought. Thank you.

Hello

Can any one tell me how one can pass a job parmater to the body of an notification activity? It works in the "Subject"

Thanks
Anil

I just conducted a test. If there are 2 reference rows returned with the same key value, the value of the column looked up is the value from the 1st row returned, and value from the 2nd row is ignored.

Thanks for the response. As I mentioned, I know what the message means, and what I need to do to fix it. The question was, in case there are more than one row returned for lookup, as it did here, does DS ignore the lookup value, or it looks up the value from the first available reference row, and ig...