DSXchange

Earlier this year I upgrade a DataStage environment from 3.6 to 5.1. I upgraded one existing project and created one new project. I now have a situation where a Unix script run from a batch job works in the upgraded project but fails in the new project. The batch job calls a Unix script: BuildFullAv...

Hi Christian One way that may work is to use an NT distribution list as the recipient instead of individual recipients. Hope this helps. John Bidondo in reply to: -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@probusiness.com] Sent: Tuesday, April 23, 2002 11:44 AM To: data...

Hi!

How can we specify multiple recipient email addresses in the Notification Activity stage? I am running on Windows 2000/NT. I have tried separating the email address with comma or semi-colon, but with no success.

Thanks again!

Christian

Hi all! Is there documentation floating somewhere that provides explanation of parameters we can use in a OLEDB stage(in the connection string)? I want to access a Excel spreadsheet and skip the first 2-3 rows. Is that possible? I also need to access FoxPro and SQL Server database and I would like t...

Paul, You are dead right. You should be able to do this in a single pass of your input data. Unfortunately, there are a number of issues with the version of DataStage you are using. Can you please advise the precise version you are using? For example, we are using 4.2.2r2, having recently upgraded f...

Vincent When you install a new project a lot of times they have permissions set to where you need to be the owner of a file to chmod or remove that file. If you look at the directory of the project then you will see an "s" where normally you see either "r", "w" or "x". You can chmod on the directory...

Hi All We have a job which puts data into several Oracle tables which have foreign key constraints so we need to make the inserts happen in the correct order. We are using ORAOCI8 stages to do this using Datastage 4.2 and Oracle 8i. Each input line from the raw data is inserted into several of these...

Thanks - that works fine. Regu -----Original Message----- From: Giovanni Boccia [mailto:giovanni.boccia@datamat.it] Sent: 19 April 2002 17:22 To: datastage-users@oliver.com Subject: Re: Clearing a hashed file from a DS routine Hi Regu, I dontt know if Ive urderstood well your needed. If you need to ...

Source code for ExecSH is in the Routines branch in Manager; it is readily adapted. Ray Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road Southbank, Victoria, 3006 Australia Telephone: +61 3 9626 6624 Facsimile: +61 3 9626 6622 Email: wurlodr@au1.ibm.com "D...

It is the routine ExecSH which is logging the command line. This is just a supplied routine to call DSExecute. You could write your own routine to call DSExecute which logs whatever you like, for example, everything except the password. -----Original Message----- From: bxdatta@regence.com [mailto:bx...

Pavan, Could you please elucidate with examples ? We are now exploring options of executing the shell script through the Datastage job control or by executing the shell by passing parameters through a restricted file. Thanks Bibhu From: pavan.marpaka@ascentialsoftware.com on 04/22/2002 12:40 PM Plea...

Try utilizing the ftppwd utility on unix. -pkm -----Original Message----- From: bxdatta@regence.com [mailto:bxdatta@regence.com] Sent: Monday, April 22, 2002 3:26 PM To: datastage-users@oliver.com Subject: supress log Hi All, I am trying to run an Oracle SP using Datastage "before-job subroutine cal...

Hi All, I am trying to run an Oracle SP using Datastage "before-job subroutine call". This is being done by using a Unix Shell script that has a call to sqlplus with the db connection parameters. All this is working fine. The problem I am facing is that the database passswords used by the before-job...

Hi all, We are looking at using DataStage CDC for Oracle. Does anyone have any experience, tips, tricks or just general comments on implementation and performance of this product. Regards, Ian ________________________________________________________________________ This e-mail message (including any...

Why cant the firewall be configured to allow the datastage client to connect. This would be a more usual approach to this situation rather than configuring products to use non-standard ports. As for port 23, no you cant configure the datastage server to use it as it is already being used by the teln...