DSXchange

das_nirmalya - the stage is well documented in the PDFs. Could you tell us what you tried that didn't work and we'll see if someone can help?

Yes, you will have a standard transform stage and a BASIC transform stage. Once you add the BASIC transform stage to a category on your palette you will have both available to you with a mouse-click.

pre-allocating the hashed file MINIMUM.MODULUS might make a difference. After the job completes, do a "HASH.HELP {file}" and it will tell you the current MODULUS, then do a "RESIZE {file} MINIMUM.MODULUS {size}" and re-run to see if the speed changes.

Use "@INROWNUM" in a transform stage. Easiest if you change your job to use just one node or work sequentially in that stage.

All writes to hashed files are "insert or update", so when writing duplicate records you will never have rejects. You will need to locate duplicates in your job; perhaps by sorting the data on the key and using stage variables in your transform stage.

No, DB2 does not have a function to convert between character sets.

If you are using the data type of "Date" and correctly convert in the source string into that format then you should have no worries when writing that to DB2.

saxena_richa wrote:...it gives some precision related error and job aborts...

IF you were to post the warning(s) and error(s) we might be able to assist.

I think you might have chosen the term "threads" inappropriately, as DS is not thread-aware. If you mean that you are running in separate instances of DataStage then you can always use the instance name as part of your sequential file name so that you don't overwrite what other concurrent runs are p...

DataStage PX has no builtin functions to do this. You can either write your own BuildOp to do this, or use a BASIC transform stage and the OCONV() function.

This would be a good case for using a Job Sequence and the "Wait for file activity" stage.

Raj,

the "Server" attribute is easy to miss, go into the stage and click on the "Connection" category, you will see "Remote Server" appear in the available properties window on the bottom right. That is where you need to enter the "Server" name.

The main one that comes to mind at first is "backward compatibility"

If you don't believe the response you've gotten it only takes about 2 minutes to write a dummy job with a row generator, a transform stage and several peek stages. Please disprove what has been said so far about using the OTHERWISE functionality.

Yes, that is what the space in the display of view data or a peek stage is.