DSXchange

Something like that or a call to DSGetLinkInfo using the DSJ.LINKROWCOUNT InfoType. And you could call either UtilityAbortToLog or DSLogFatal.

DSguru2B wrote:In the constraints, scroll right, you should be able to see 'Abort After' column.

Fixed that for ya.

Sure, that's a different requirement. I'd setup something 'after job', a routine that checks the row count down your reject link, let's say, and then aborts the job if the count is non-zero.

Oh, and it can be effected by your 'Key' columns. Bind variables in the 'where' clause are sub'd in from the Key columns, 'data' columns are bound in from the non-Key columns. When applicable.

The question mark stands for each column defined in the job. I much prefer the numbered Oracle parameter markers as they are more flexible and can be reused. If you have X columns than your can only have X '?' bind variables - and the order that there are fulfilled is based on the column order in th...

You don't need to do anything 'special' - just set the Abort After Rows value to 1 in the Reject link constraint.

Getting late in the game, but just in case anyone is wondering... This update is expecting to be run on the console and so have access to a GUI display. I just telnet in from my PC via putty and that was causing the abort. In my case, I couldn't follow the instructions on How to patch a JRE or SDK a...

You can use the Oracle wire drivers that ship with the product, they do not require a client.

I might be hijacking the thread now. But Iam designing one such job with Database lookup. Large volume with 4 keys. For lookup purpose, Iam going to unload only the new created artificial key. I felt its saving space as well as more efficient. Hence going for synthetic key. Would you recommend that...

That's because you don't have a full client installed - you have that new fangled "instant client" that is new with 10G. Search the forum and see if anyone has mentioned successfully using the Instant Client with DataStage.

Ah... so now the complete picture of what you are doing is starting to emerge. I don't have time for a good answer here, need to get my butt out the door. Your Minimum Modulus of 1 (the default) for the hashed files is way too low for your volume. And breaking this one file into two because of the 2...

Why even start a discussion about a composite key? The OP has stated the hashed files all have a single key field. I would simply concatenate the multiple fields together if I wanted to build a composite key. But again, I wouldn't bother for 4 key fields, that's not going to help with build speed of...

When you call it from TOAD or any other sql tool within the instance, you dont need to prefix the stored proc. with the schema name. But within DataStage you do need to fully qualify the name by prefixing the user to the stored proc. No, you don't. The rules how Oracle derives ownership don't sudde...

You are right, CRC32 will give you unique single field value for combination of several fields. So you can reduce the over head of doing the lookup for all the fields. But you need to make sure, while preparing the CRC field, the datatype and length should be same, else you will end up in getting d...

asitagrawal wrote:I think u assumed something wrong.....

Doesn't matter - you are still seeing the wait incurred while the cache flushes. I've never seen a burning need to turn that on, try it with it off and see what the difference is.