DSXchange

I always advocate using a naming convention for jobs (and, since it became possible, categories). Then we can use the Filter in Director to see only what we want to see. -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com m One clic...

Hi , I have following questions on datastage release,multiple instances, users and permissions: 1) If we create a project, and import datastage jobs into it with no release job, datastage operators wont be able to see the log. 2) If we release jobs and then import, because of the multiple instances ...

Have you tried Sort Stage? I am on DataSatage Release 4.2 so I dont know if V5 has a Merge stage or not. Kim-Lien Nguyen Kim_L_Nguyen@raytheon.com Work: (972) 205-7943 "GEORGES DAHER" cc: Subject: IT IS URGENT 12/10/2002 11:34 AM Please respond to datastage-users DID ANYONE USE THE MERGE STAGE BEFOR...

Hi, We ran in to a problem in our project. We had a load run 2 days ago. We create around 7 hash files using job1 and then use those hash files as lookups in job2. At that time the load ran as expected. We had to do a reload yesterday. We ran thru the process of running job1 and then job2. This time...

DID ANYONE USE THE MERGE STAGE BEFORE I AM USING DATASTAGE V5.1 I CANT ACCESS THE FIRST FILE NOR THE SECOND REGARDS Georges Daher Analyst Programmer Solutions Delivery Unit IT Department Banque AUDI S.A.L. Direct No : 977467 /Ext. : 1467 Fax : 961 1 980210 /Po.Box 11-2560 E-mail :Georges.Daher@audi....

Hello Guys did anyone of you guys had used The "Merger" components because I am getting that error "..MERGE26: Link property retrieval error" thanks Georges Daher Analyst Programmer Solutions Delivery Unit IT Department Banque AUDI S.A.L. Direct No : 977467 /Ext. : 1467 Fax : 961 1 980210 /Po.Box 11...

Ray, Chris, Thank you both for the information. I was tossing some ideas around but you advice helped me look in the right direction. Thanks again himanshu -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Monday, December 09, 2002 1:21 AM To: datastage-users@oliver.com Su...

One suggestion is to have another link going from your transform to a hash file or temp table (whatever DBMS). The hash file/temp table key could be a fixed string such as "AUDIT" and the other columns could be @OUTROWNUM and whatever else you need in your audit record. Given the key of the hash fil...

Hello guys I have a job where I have 10 different type of products for each one of them I should add date to it coming from 2000 till the now and this job should run daily and the number of products could increase at any time, I am reading the products from a DB2 file and the file date I created, se...

Hi Im working on getting a hierarchy loaded into SAP, and i think that i have setup the primary and foreign keys correct, it seems so when stepping trough the stage, but when data arrives at SAP the the IDOC looks different from my input. The input to the stage has a list of Parent and Childs, and i...

-----Original Message----- From: Moderator [mailto:moderator@oliver.com] Sent: Thursday, 6 June 2002 5:26 AM To: datastage-users@oliver.com Subject: MONTHLY POSTING - DataStage Users List MONTHLY POSTING - DataStage Users List As of 5 June 2002 the DataStage Users discussion list had 642 subscriber ...

Forum Users:

Due to security changes on the server hosting the DataStage forum, the link to Compile All download has been changed. Unfortunately, emails were sent out with the old link. To receive the new link for Compile All, please email admin@tools4datastage.com.

Thank you.

Hi Basil, we use PVCS as source control system. At the DS 3.5-times there was no DS-Version-control yet available and we integrete also in PVCS other elements like unix-shell-scripts, sql-scripts, access and so on. We have written for our purpose a tool called dsmove. With this tool we are now able ...

In a server job, you can send an extra output link from the Transformer stage, with @OUTROWNUM or with a link row count, and pass this through an Aggregator stage where the grouping rule is either Last or Max. Then send this single row to your audit file. If its a mainframe job, which I suspect is t...

At my most recent project we (they) investigated a couple of source control mechanisms - cant remember which ones off the top of the head - and eventually went with Version Control plus two custom DataStage jobs, one to toggle the read-only state of a DataStage object and the other to perform a chec...