DSXchange

Prior to release 5.0 you need to create a Job Control routine. This is done from the Job Properties window. Open the on-line help and find Job Control as a topic. You will find it possibly easier than you expect to create simple job dependencies, since DataStage actually writes most of the code for ...

The job sequencer was new in DataStage 5. It was not available in 4.2 -----Original Message----- From: Bruce William [mailto:bwilliam_ds@yahoo.com] Sent: Friday, 13 June 2003 3:04 PM To: datastage-users@oliver.com Subject: Job Sequencing Hi All, We have a requirement to run the dependent of jobs eff...

Hi All, We have a requirement to run the dependent of jobs effectively so that there wont be any clash(eg., waiting for table locks etc). I read (archives) about Sequencer stage which will help to achieve this. On which version this is availabe? where can I find the documentation? We are on DS4.2. t...

The system variable @USERNO is the DataStage id of the (background) process running the job. Including this in the file name should get close to guaranteeing uniqueness. Similarly, SYSTEM(9) returns the milliseconds since the last second. For example: FileName = "TheFile_" : @USERNO : "_" : DATE() :...

Thanks Craig and Michael, both of your solutions work for me in making my file type unique. So, a big THANK YOU! Further details for those interested: >From your email Craig, I looked for freeware equivalent code and found pslist.exe at m It runs the same on NT 4 and Windows 2000. Doing a "pslist id...

There is a builtin transformation called KeyMgtGetNextValueConcurrent that could be used to return a unique seqential number - it was originally intended to be used to generate unique surrogate keys across multiple jobs, but perhaps this could be used? The logic is pretty straightforward so you coul...

Too bad about the Randomize, I had figured it took time of day down to the millisecond so it would be very hard to actually start two jobs "at the same time". [shrug] One solution would be to move to a Unix server. After poking around via Google, I did find that you *can* get pid and ppid informatio...

Thanks Craig and Lester for your answers on how to ensure uniqueness. > Craig, I still have the problem if the jobs are scheduled to run at the same time. The random numbers are sometimes identical. So, I looked into the options you shared Lester. > We call the custom routine from all over the place...

Verify your file definition in DataStage is using comma separated, because if you read your error messages it says: ... Delimiter for field "Rule_id" not found; input: {R u l e _ i d 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 J e _ i d 20 20 20 20 20 20 20 20 | 20 20 20 20 20 T r a n s _ T y p e .....

its a comma separated file. -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, June 12, 2003 11:27 AM To: datastage-users@oliver.com Subject: RE: Job Phantoms before Finishing Is your file pipe or comma separated data? -Ken --- "Babatunde.Ebohon" wrote: > ...

Is your file pipe or comma separated data? -Ken --- "Babatunde.Ebohon" wrote: > Hi all, > > Im having a problem extracting/viewing data from a > flat_file. I new to datastage and i dont seem to > know why this particular file is having difficulty > being read. Does anyone knows what the problem > co...

Hi all, Im having a problem extracting/viewing data from a flat_file. I new to datastage and i dont seem to know why this particular file is having difficulty being read. Does anyone knows what the problem could be? Here is my file: Rule_id,Je_id,Trans_Type_cd,rev_type,price_type,adj_rea_cd,paymt_me...

Hello, I have a job that extracts data from oracle - transforms them - and writes into another oracle stage. It works! - but in some cases it creates a job phantom before finishing. DataStage Job 187 Phantom 8609 Program "JOB.1097715596.DT.1283961672.TRANS1": Line 217, Variable "$R3" previously unde...

Alejandro, Its all a matter of what you want to cleanse. There are a lot of people that do name and address cleansing. You would have to review their published matching statistics and libraries that they support to decide which works best. For other types of data cleansing, make sure you have a flex...

Hi Senthil, do you simply want to know if it could be solved with DataStage or do you want to get the solution as well? Yes you can. If the file looks like the first part: EmpNo EmpName 1 John Address Phone India 444534534 USA 324234234 and continues like this: EmpNo EmpName 2 Catharine Address Phon...