DSXchange

We are trying to read a COBOL file using Sequential and / or Complex Flat File using Datastage Server jobs. The structure of the file is comlex like there are eight occure clauses and 8 redefine clauses . we have tried to read this file using each and every approach. I think the file has parallel Oc...

If it ireal time example then how one employee can have more then 1 salary?

Hi Arnd,

I tried to find it out at page you have provided but did not find any DS related stuff.

- Mandar

Hi,
I want to know DataStage Engine Commands (which are executed from administrator module). Can somebody suggest me from where I can get all those?

- Mandar

Hi All,
Thx very much for the i/ps i got the solution. :D

Hi sainath,

Thx for early reply
Can you be more clear on the solution i mean where should i check the "wc -l" ? my job flow is :
SeqFile--------->Transform--------------->HashFile

Hi All, I have 2 sets of job in first jobs i am creating a sequential file, and in the second job i will be using this sequential file to load the Hash file, but the second job should not get executed when the output of the first job i.e sequential file is empty because what happens is when my sourc...

Hi All,
I have scenario here, the job shldnt get executed when the source file is empty or with 0 records in it How to achieve this in the job? do we have use any constaints at job level

Thanks
Mandar

Hi Sainath,

Can you be more clear on the Trans stage part i mean how to go about it?

Arnd,
I tried using Str(RepatString,500) function its not working.

Hi Ray I have tried using the solution you mentioned and was not able to generate the dates from one input date i need to generate it using one input date and it should get generated in the first run that means when i run my datastage job the dates should get generated for all the five years can u s...

Hi, I have one row of the data i.e a date value 2000-01-01 and i am supposed to generate the dates till 5 years so if my start date is 2000-01-01 then my last date for the 5 years would be 2005-12-31 How to achieve this using a job? Roy can u give me some more details regarding this? would appreciat...

hello all, I would like to generate a calendar year. My input would be a Date such as 2000-01-01 My date value is YYYY-MM-DD. I would like to get the next 5 years from the input date. For example : input date: 2000-01-01 Output date should be: 2000-01-01 2000-01-02 ... ... .... 2001-12-31 .... till ...