DSXchange

Not sure whether you have searched completely.
http://www.dsxchange.com/viewtopic.php? ... AEMON_PROG

Or you can workaround with Iconv/Oconv.
'Oconv(Iconv(date,"D"),DM) + counter' to add up the month.

So you can make use of StartLoopActivity and EndLoopActivity to pass multiple parameter one after other.

Hi Ray,
May I know what additional information can ge gathered from 'J\68\V0S0P0 '?

Unix is an ideal OS to handle multiple process simulteneously without huge over head. That is the one of the big reason Unix is prefered for parallel operation.

opdas wrote:its working when i hash parton both the input set....but am i doing the right thing????

Yes you are doing the right thing.
As mentioned, both the dataset need to be sorted and corectly partitioned across nodes to get the correct result.

I guess selecting the same table for Partitioning table forces to Entire partition.

For subsequence you can give the execution action as Run and for job you can give 'Reset if required and rerun'
For multiple job compile, you can use 'dscc' from client. Search for the same.

Try to sort and do a hash partion based on Joing key prior to join or merge for the both the input. So that the joining key will be similarly distributed across nodes for both set of data.

Are you triying to uninstall existing versions of Client in the PC and reinstalling the new version?
Or trying to override a new version.
Check for the running application whether datastage services are running.
Have you tried to reboot you machine and reinstalled?

Change capture stage is build to run on parallel execution mode. It shouldnt give you any undesired result. But you could mention what is that you desire to get and what is the output from the stage. Perhaps you could concentrate on Partiton method used.

Yes you can.
Pls do a search on WRITESEQ.

If you specify a table name, the partition methond is derived from the given table. By default if it is not mentiond it will follow sequential mode.

Is this only for this job?
There is a chance where the imported dsx might not be properly updated DS_JOBOBJECTS. Try to export and import again.
Also do a COUNT DS_JOBOBJECS from TCL to ensure the links in the DS_JOBOBJECS is proper by getting a valid count without any error.

If you login to adminstrator client, selecting the project properties on the general, you can find a button. Either it can be Protec project or Unproject project. If is is Unproject project, it ment is has been already protected. You will require dsadm access to alter the state of the project.