DSXchange

Execu-Sys, Ltd. is currently recruiting for a Fortune 100 client in the NY/NJ area seeking an experienced DATASTAGE professional to be their "in-house guru"; experience w/ AIX & ORACLE a plus. Excellent salary w/ world class benefits-for more information please contact Matt Hart @ (800)423-1964 x302...

Make a copy of the routine in manager, rename it and then you will be able to edit the code. -----Original Message----- From: Phaneender Aedla [mailto:phaneender_aedla@mindtree.com] Sent: Wednesday, March 06, 2002 12:26 AM To: datastage-users@oliver.com Subject: Utility Run Job Hi, I use the Utility...

If you have the default values specified in the job which you can set from the director you do not need to pass the information at all and the job will use the default values. This might be a way for you to get around this. Rick Schirm VP Operations DCS-Strategies / Application Performart Phone : 81...

OK, point taken ... I was a bit too quick to respond. I have never used the "Utility" routines. Not even sure if I recall seeing them back in DataStage 3.5 where we started our development. We already have our own equivalent of these. Not even sure why it needs to log the parameters at all. DSRunJob...

Hi all,

I want to make a routine that writes in a table received by parameter? Is that possible?

Thanks in advance.


Nuno Pimenra

Hey David, Thanx your respond. Well......I will try this and let it back. But how can i work with Pivot Stage? ORAOCI ----> Pivot ----> Transformer Stage -----> ORAOCI Is this correct? But I have 20 Columns in my Source table and One and only one lookup. So each column have to check with Lookup and ...

Hey All, Im new to DataStage tool. Right now Im using DataStage 5.2 Client in Windows 2000. And DataStage Server also in Windows 2000 and Version 5.2. And Im using ORAOCI8 to both Source and Target sides. Backend is Oracle 9i. I have a table in oracle src_one (Source table) and the availble columns ...

The parameter type is Encrypted. -----Original Message----- From: David Barham Sent: Wed 3/6/2002 11:02 AM To: datastage-users@oliver.com Cc: Subject: RE: Utility Run Job Very simple to fix. Change the parameter type to "Encrypted". -----Original Message----- From: Phaneender Aedla [mailto:phaneende...

This is a topic for an orphaned message.

This is a topic for an orphaned message.

Very simple to fix. Change the parameter type to "Encrypted". -----Original Message----- From: Phaneender Aedla [mailto:phaneender_aedla@mindtree.com] Sent: Wednesday, 6 March 2002 3:26 PM To: datastage-users@oliver.com Subject: Utility Run Job Hi, I use the UtilityRunJob function in a control job t...

Hi, I use the UtilityRunJob function in a control job to call some sub-jobs. In the log of the control job, all the parameters which are being passed to the sub-jobs are shown. The problem is how to stop the password, which is passed to the sub-jobs, from being shown in the log. I thought of comment...

>Hi, > Where do u find an exhaustive list of all the commands (like CT, DS.TOOLS etc)? > >Regards, >Aedla. 1. All of the DataStage core manuals install with DataStage client software, in a Docs folder. 2. Manuals for plug-in stages are on the installation media (or web site) in PDF format. 3. Manual...

We encountered this error message when we exceeded the max processes / user, called maxuproc (AIX). The dsjob command creates connection processes that do not immediately end. This seemed to cause a "build up" of the process count. We were using dsjob within shell scripts to run the DataStage jobs, ...

Hi guys,
Somebody told me that I can have a Short message on my cellular phone to indicate the status of a running job whether it finishes successfully or aborted. Does anybody know how to enable this?

Thanks.