For Execute Command activity there is an activity variable "$CommandOutput" that stores the output of the command.ivannavi wrote:Hey, I didn't know output of the command was available in Execute Command Stage! Only return code for the trigger.
Where can I find output?
Search found 196 matches
- Tue Jun 05, 2007 6:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Additional text in the output of Execute Commant Stage
- Replies: 11
- Views: 4488
- Tue Jun 05, 2007 5:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Additional text in the output of Execute Commant Stage
- Replies: 11
- Views: 4488
- Tue Jun 05, 2007 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Additional text in the output of Execute Commant Stage
- Replies: 11
- Views: 4488
- Mon May 28, 2007 4:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Additional text in the output of Execute Commant Stage
- Replies: 11
- Views: 4488
Done : DSD.RUN indicates a run of a server job. Now why this is appending to your Execute Command Stage can be figured out only by knowing what exactly your are doing with Execute Command Stage. Thank you for your reply In the Execute Command Stage I am running the following code: grep 'TRAILER' #$...
- Mon May 28, 2007 3:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Additional text in the output of Execute Commant Stage
- Replies: 11
- Views: 4488
Additional text in the output of Execute Commant Stage
Hi, I have a sequencer job that has three stages that are called in series Stage 1: Job Activity Stage - It calls a multiple instance job (Job1) Stage 2: Execute Command Stage - It executes a unix command. Stage 3: Job Activity Stage - It calls another job (Job2) based on the output of unix command ...
- Fri Jan 27, 2006 4:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update access to the target database
- Replies: 3
- Views: 2261
Re: Update access to the target database
We dont have update access to the database with the username we provide in the mappings to connect to the target database. Please let me know why we need an update access to the target database in normal scinario? If you need to update any row on any table you need an update access on that table. F...
- Wed Dec 21, 2005 11:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Split Hash File vs Universe Table approach
- Replies: 8
- Views: 4519
- Mon Dec 19, 2005 4:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Split Hash File vs Universe Table approach
- Replies: 8
- Views: 4519
Thanks Ray and Arnd, Splitting the key column logically is not possible. So, if we create say 5 files there is no way we can ensure that the data would be evenly distributed across these 5 files. Certainly creating only 1 hash file would be a bad option because the size of that file would be around ...
- Mon Dec 19, 2005 12:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Split Hash File vs Universe Table approach
- Replies: 8
- Views: 4519
Split Hash File vs Universe Table approach
Hi, As per a business requirement we need to make a lookup to a table based on one key column. The lookup table has 25 million records and a direct table lookup would kill the job performance. Hash file probably is a good idea but we do not want to create the hash file because of two reasons: 1) We ...
- Wed Jul 20, 2005 11:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing values fron one job to other
- Replies: 7
- Views: 3078
1)Now how do I use the UtilityHashLookUp(HashName,'Value',1) in the seq In the hash file define two colums DummyKey and Date. In Job 1 hardcode the value of Dummy Key to 1 and pass your date value to column Date. In the sequencer Call UtilityHashLookUp using RoutineActivity Stage. It asks for three...
- Wed Jul 20, 2005 11:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing values fron one job to other
- Replies: 7
- Views: 3078
Re: Passing values fron one job to other
Hi, I have a requirement, where my First job gives me a time stamp. Now I need to pass this on to the Second job , where it wuill be used in the ORA stage Query . How do we go about this, thanks :roll: Hi Vinay, Two ways to do it: 1) Store the date in a hash file in first job. Read the hash in the ...
- Wed Jul 20, 2005 11:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Replacing Carriage Returns in fields
- Replies: 9
- Views: 5546
- Tue Jul 19, 2005 3:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to avoid blank row in Sequential file
- Replies: 8
- Views: 4027
- Tue Jul 19, 2005 2:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Replacing Carriage Returns in fields
- Replies: 9
- Views: 5546
Thanks for the help Hi tjmalone, did it work for you. If yes could you please send me the exact that you used. Actually we were facing a similar issue in our project but we didn't know using EReplace or Convert how do we first read a CR or LF value. So, what we did was we used Iconv Oconv to conver...
- Tue Jul 19, 2005 2:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to avoid blank row in Sequential file
- Replies: 8
- Views: 4027
can use any of the follow 1) can use a transformer/filter to check all the colum for null 2) can use aggregator to group by any unique column and filter out the blank row 3) If every other rows are unique, can use Remove Duplicate Stage Kumar, just curious to know if we have any Remove Duplicate St...