DSXchange

Hi, I have a problem where in I have to give two input links to a transformer stage and get a single output link. But the transformer stage takes only one input link and takes any other link as reference link. Can you suggest me how to give more than one link to the TX stage input. Thanks, Murali __...

Hello All, I am trying to accomplish unattended weekly backups on multiple projects using the command line interface and am not sure how to handle potential prompts and errors. My approach has been to write an executable VB program that will shell the command line, looping through the projects. Each...

Hi Denzil, How about exporting that job and import again logging to DS with the new user?? I think that will be better that change the permission to all the interested file (AND DIRECTORY). Maybe will be also good to put that new user in a DataStage group, so that all the users belonging to that gro...

hi , is there any site where i can find samples of datastage files that is .dsx files or zips.i am currently developing a complicated ETL process using datastage. any information on this would be of great help or if some one can send some good datastage application developed it would really help in ...

-Concerned about sending passwords across your network and maintaining cumbersome scripts? -Spending too much time dealing with mistyped parameter names? -Looking for a way to modify design and runtime parameter defaults in a production environment? DCS-Strategies is pleased to announce the release ...

Hi, Ive a problem scheduling a job. Im trying to schedule a job "Every" specified day using root account without success (no warning message, no entry into the crontab). DS does not appear to "communicate" with the operating system. Im working on HP-UX with DS5.1. Anybody can help me?? Thanks in adv...

-Concerned about sending passwords across your network and maintaining cumbersome scripts? -Spending too much time dealing with mistyped parameter names? -Looking for a way to modify design and runtime parameter defaults in a production environment? DCS-Strategies is pleased to announce the release ...

The forum at www.tools4datastage.com/forum maintains an archive forum of all posting to datastage-users@oliver.com. -----Original Message----- From: Doreen N Muller [mailto:Doreen.Muller@ipaper.com] Sent: Monday, May 06, 2002 9:19 AM To: datastage-users@oliver.com Subject: Re: datastage-users Digest...

This is a topic for an orphaned message.

Is there a way to see old postings?

It will use the SQL that you enter as the Before/After SQL to be executed. I believe you may have my suggestion mixed up with the before/after Job routine which may be called. Open the Target Stage (ORAOCI8 I assume), click on the Input tab, click on the SQL tab, click on the Before or After tab, en...

Hello Lester; Thanks for the email. Do you have any example of the script? Like I can choose "ExecSH", what should goes in Input Value? If you have example of the script, can you pass it to me? Thanks for your help. Regards RL Date: Thu, 2 May 2002 12:03:58 -0400 To: datastage-users@oliver.com From:...

This is a documented bug, if you call text support they can give you the case number. There are no work arounds except hardcoding. Instead, try executing a shell script that takes as parameters your parameter values and does what you need. Good luck! --- Kittisak Puengpunyadee wrote: > All, > In job...

All, In job sequencer, I used the exec-command stage for executing a shell command. The command was supposed to echo a string to a file in a directory. The problem was that when the parameter was used in place of the actual directory name, the problem occurred. The target directory was not found. I ...

Guys The following worked for me on a Sun ver 5.8: $ mkfifo fifo $ zip stuff temp.txt $ unzip -c stuff |grep "," > fifo My job uses "fifo" as a sequential text input file. My input file looks something like: $ head temp.txt "9910734651854","1" "9910731405009","2" "9910733237004","3" "9910733867003",...