DSXchange

The best way to answer this question it to draw it on paper. If your data are partitioned by A, B and C, will values of C all be on the same partition for any given value of C? The same question must be asked of values for B. And, of course, the answer is yes, so - provided that you preserve that pa...

Other than manual, nothing in version 8.x.

But there are various DSX cutters around - a Perl version was posted quite recently.

Parameter values can not be changed within the job that consumes them. They are read when the job starts and are fixed thereafter. As noted, you need to handle your casing issue prior to executing the job run request. You can do so very easily in a job sequence, particularly if you are using version...

Yes.

DS.CHECKER does not touch job logs for jobs that exist in the project. It must be run with exclusive access to the project, and cleans up any "orphan" files/tables left over from incomplete deletion of jobs. DSPARAMINSTS is a record in a hashed file in which the parameter values entered wh...

... but you can direct it to a Sequential File stage that appends to /dev/null if you wish to discard the records.

That is correct. If you use a server job to do so, then you can park the retrieved value in the job's user status area, which can be retrieved using the $UserStatus activity variable of the job activity that invoked the first job. A server job is preferred to a parallel job when only one row is to b...

Thanks for the quick reply I'll try this and get back to u if i face any difficulty in implementing Why do you believe that U specifically will be able to assist? The second person personal pronoun in English is spelled "you", not "u". Please use a professional standard of writt...

The map for hashed files must be NONE if they are only to be used within DataStage. A map of NONE will handle every character "as is".

I am assuming you are supplying one date and returning rows for which that date is between eff_date and term_date.

In this case you require TWO key columns; id and date.

Sequences need to be able to write on the client when being compiled. Is your DataStage client installation directory writable?

There are three servers that must be running.
IBM Information Server
WebSphere Application Server
DataStage server

Welcome aboard.

PrachiTrivedi wrote:we have recently upgraded from 7.5.2 to 7.5.1.

Is that correct?

What ODBC drivers, and at what versions, are you using?

Not in DataStage. But you can change the default tablespace that the DB2 user is using within DB2.

Where did you read/learn about this environment variable? Surely the same location will document the effect of using it. (I don't know the answer off the top of my head, and can't find it in the standard manual set.) It's one introduced by Ascential.