DSXchange

My intention is to export selected Datastage parallel jobs(.pjb), sequencers(.qjb) and parallel Shared containers(.psc) into an isx format through CLI/istool. Before starting the export process for *.psc, I am trying to validate the container name. Step 1: Looking for the container under a PROJ: com...

Could other elements of Datastage like Shared Containers/Routine be exported using this istool command? My observation while using dsjob -ljob <proj>, this wasnt able to find any shared containers on this project. Any workarounds for this?

Thanks for the quick reply.
But my concern is to find out the JobName itself.
I know the file name which is being created by this JOB.
With the help of this file name, i need to find out the Parallel job name.

Hello All, I have a parallel job No2 which is looking for a file as a source. But the problem here is, the job No1 which creates the particular file is not generating proper file, which is leading to abortion of the job No2. I am trying to look for the Job No1 among many jobs in repository so as i c...

Changing target datatype to VARCHAR solves the problem.
Is there any Other way out to resolve this issue without changing target metadat? I am looking for the resolution without changing the target metadata.
Please suggest.

Hi, I have a column of datatype CHAR(20). When the DataStage job loads data of length 15 into it, it pads the remaining 5 spaces with unprintable characters (these are represented by squares in aqua data studio). This is happening with all CHAR datatype fields at DB2 Target. Is there any global sett...

Hello Members, In a parallel job i need to load(UPSERT) into a DB2 Enterprise target table wherein i need to propagate the "CurrentTimestamp" to a field LST_UPDT_DTTM(type= Timestamp). I have used a transformer wherein LST_UPDT_DTTM coloumn derivation is "CurrentTimestamp()" The ...

The unix rm utility cannot be used to delete the datasets. The orchadmin delete or rm command should be used to delete one or more persistent data sets.

Thanks for your instant reply.
But will that give the information about the particular column name among hundred columns of a record, which is modified?
Please let me know your comments on this.

Hi,
I need to compare and capture the changes in after and before record. Along with this I need to find out which particular field value is being changed in case of any discrepancies. How to go about this? Which stage is best for this task: Change Capture/Compare/Difference stage? Please suggest.

Hi Can any one please answer following questions for me: 1. What is the difference betwen Merge Stage and Lookup Stage? 2. What is the diffrence between the Dynamic RDBMS Stage & Static RDBMS Stage ? 3. What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standa...