DSXchange

Not sure for Windows, think it is all in the Environment variables you have defined - but it is all spelled out in the documentation provided.

Yes, but how have you configured the Merge stage? How large are the input flat files?

An Exact search for "month end date" will answer your question.

How can anyone answer that for you unless they are clairvoyent? You haven't given any details like database, stage, etc. We can guess Teradata, but that's about it.

Has or had? Sparse lookup.

While the ability to tnsping instances is good, it's no indication that anything Oracle will work in DataStage. Have you specifically configured DataStage for Oracle?

I know. Hence the

Based on what you posted, of course, and a little bit of that 'rithmetic stuff.

ray.wurlod wrote:a sparse lookup will get the next value and the next value and the next value...

Pretty sure that's what they want.

jherr22 wrote:in other words, each row of the input file needs to have a new nextval value joined to it.

Excellent. Please mark the thread as Resolved using the big button at the top of the screen.

D'oh! :D

ray.wurlod wrote:Because DataStage writes it there if it's an ExecXXX subroutine.

Which is exactly why I suggested creating a 'Silent' version of the routine that doesn't log that stuffs or since it's all custom code, switch to using DSExecute directly.

Now, hold on a darn minute. This isn't your thread so let's not steer the boat off course quite yet. You need to start a new thread if you want to talk about your problems.

Ok, but that still doesn't change the fact that the flat file really isn't your problem. What can you do to improve the query speed? What array size are you using?

Yikes. Interesting idea, but why not just not write it there in the first place?