DSXchange

Are you reading a DOS file with EOF in it in UNIX environment. You can use below method to remove EOF character from the file. Use it in Before Job routine in Job Properties as ExecSH method tr -d '\032' < sourcefilename > intermediate_sourcefilename use intermediate_sourcefilename in sequential fil...

Hi, I get a file from mainframe. Its a fixed length file. There is a amount field which is of zoned data type. My requirement is to aggregate this data and out put that in zoned data type format. Which datatypes should I use in Datastage? I believe I cannot use decimal data type for adding zoned dat...

Hi Kim,

It doesnt work. I tried options like -Q, -QUIET
But they also did not work.

Hi Kim, I implemented the import script and working fine when I run it from the DOS prompt. As mentioned before I am using PVCS mover option to import these jobs by selecting the latest dsx from PVCS. Now, what is happening is when Datastage tries to import jobs it shows some prompts which has to be...

Hi, I did not mean to say your script was incorrect. I was just trying to explain what I am trying to achieve. I am using similar script to get all the PROJECTS on that server. I am sorry if my writing suggested something else. By sequence I meant Steps they are executed that is first job is Extract...

Hi Kim, I used the logic mentioned by you to get the Job names in a sequence. I was wondering whether i can find out in what sequence they are called like 1) Extract 2) Transform 3) Insert 4) Update This would help me in showing the status of the sequence jobs in the same sequence they are called. A...

H Ray,

I was trying to access the <ProjectName>.DS_JOBS and was getting below error
Table does not exist.

Is there anyway, I can call this from Universe stage.
The reason I am doing this to list all the ojest from all the projects we are working on and load it into the database.

Hi, Is there a way to find out job names used in a sequence. My aim is to populate two tables. First table will contain All the sequence names and other one will contain job names and they will be tied up to sequence table. This wil help me to know which sequence contains which jobs. I wish to creat...

Hi, I have two Datstage projects RETAIL and FINANCE I need to access DS_JOB and DS_OBJECTS of RETAIL project from FINANCE project. Basicallly, I have written Server jobs which is using UNIVERSE stage and trying to find out objects used in each Project. To get the objects from each project I have to ...

Hi Kim,

Thank You Very Much for your timely help.
The script is great...

Hi Kim, Below is process we are trying to follow for moving the jobs from Development to QA 1) Developer will Export the jobs using Datastage Manager into .dsx format 2) Developer will Check In the dsx into PVCS 3) QA will get the latest version of dsx from PVCS and move them into QA This process of...

Hi Ray,Duke, We are using Enterprise Edition of 7.5.1.A. Actually, I have to give solution to my client by end of day today or we have to find some other solution. My client doesn't use version control of Datastage. They use PVCS to store the DSX and wish to automate the process of taking the latest...

Hi, I have a dsx which contains one Job design exported from Datastage Manager. My aim is to import this job design from command line and not through Datastage manager. I checked the documentation and I was able to import the Job executables rather than Job designs. So when I import job executables ...

Hi, I have input metadata of 240 columns. This input metadata is used in Buildop. When I compile the Buildop I am getting an error ###################### Operator Generation Failed buildop -f -BC g++ -BL g++ -C buildop -H buildop -O buildop -W buildop buildop/EIM_Audit_Log.opd ##E TCBO 000000 3: Err...

Change your job desing to capture all duplicate primary keys. Add a remove duplicate stage with a reject link. Rohit, My problem is I am able to get reject records in the reject link or file when there is primary key constraint violation. There is no failure of job. It does not tell me in the Direc...