DSXchange

Please try searching the forums, this has been asked and answered a number of times in the past.

Hamper the performance? It won't be the most performant mechanism choice regardless of join and isn't how I would choose to solve that problem. Me, I'd bulk both files into work tables in my database and do the join there.

Not from DataStage, no. Doesn't mean your SA couldn't be enlisted to help 'nice' the processes once started or perhaps give you the ability to do the same.

Database? Is the stage generating the 'Syntax' to call the procedure or are you? I've had problems using Oracle stored procedures with no parameters as you need at least one column on the triggering link and then it gets upset if you don't bind that column into the call. So, I've added a 'dummy' IN ...

Start by asking a more specific question. What problem are you having?

If the metadata is identical across the files, why not just concatenate the files together from the command line?

Post the actual errors.

At that level, this is something you have to design into your individual jobs. This typically involves a 'breadcrumb' system - something that lets you know how far you got into the processing and a mechanism to skip back to that point if the last run did not process 100% of the input.

Perhaps, but only if your database supports the concept of an 'identity' column.

I don't have an answer for you, but please delete the two extra posts on this subject you put in the Server forum before someone replies to them. If you don't know how, simply click the 'Edit/Delete this post' link inside of each and rather than change anything, check the 'Delete' option at the bot...

Not sure why you would even consider using a 'generic' stage like ODBC over a 'native' stage for any database unless you had absolutely no other choice. And 'absolutely no other choice' basically means there is no native stage available for your database. You would lose any Oracle-specific functiona...

Ah... glad it was as straight-forward as that to resolve.

Explain what you mean by 'we moved our DataStage server' or what 'moved locations' means as they are fairly ambiguous statements. You physically moved the box? If you mean the software, it usually helps to explain how you did this 'move'. If the latter and you haven't already tried this, I'd suggest...

Conversation migrated to the other post on this subject.

Because it's REQUIRED and the expensive product your company purchased does not work without them - what the heck else does he 'need' to know? And it's just select privileges, for heaven's sake, not truncate or rearrange or randomize that you need. I really don't understand DBAs that get all puckere...

DSGetLinkInfo actually.