DSXchange

With the ever increasing DataStage community, the proposed oliver project i am sure will be very useful for one and all. However it requires an expert to sort out the information and filter the not-so-good posts. Also since there have been drastic changes between the versions, categorising on the ba...

hi ray,

This is very informative for me. Thank You.
I am using the 5.2.1 version of DataStage, so wasn't aware of Parallel Extender.

Rajesh

Since you need all records from both the files, this is a case of full outer join when joining two tables. Here we have a case of joining two files on similar lines. If u are working on a server job, the join stage over there has the option of full outer join. Simple solution. If u are working on a ...

hi sumit,

The problem could be in the program or in the interpretation of the test result. Shudn't be ne issue with DataStage.

hi ray,

i know wat a server job is nd wat a mainframe job is, cud u plz xplain wat a parallel job is?

Thank You.

Rajesh

In certain cases, the jobs get locked preventing access to the user and disabling deletion of the job from the project aswell. In such a scenario, the DataStage Server can be restarted which releases the lock on the job. However, since this process involves loss of time for all the users connected t...

The data from DB2 on Mainframe platform is to be transformed and loaded to ORACLE on Unix platform. My DataStage server will be on the Unix machine. DataStage Clients on various Windows machines are connected to this server. I have three ways in mind to achieve the above mentioned data transfer. 1. ...