Search found 111 matches
- Tue Jun 16, 2009 5:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Looping in DataStage
- Replies: 17
- Views: 29921
Re: Looping in DataStage
Hi Santosh, If i were you, i would have implemented this logic using a basic routine for the looping logic instead of opting for a sequence job. In the sequence job we can specify the count of loops to be executed or for an 'in list' for the counter. But i dont think we have the option to break from...
- Thu Jun 11, 2009 4:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: giving filepath as argument in server routine
- Replies: 3
- Views: 2605
Re: giving filepath as argument in server routine
Hi,
Did you try passing the filepath value as a string to the routine.
Or Can you please give more details about the method you are following and the error encountered?
Did you try passing the filepath value as a string to the routine.
Or Can you please give more details about the method you are following and the error encountered?
- Tue May 19, 2009 12:52 am
- Forum: General
- Topic: can the absolute path of a script be a variable ?
- Replies: 3
- Views: 2699
Re: can the absolute path of a script be a variable ?
I'm trying to parameterise the path of the script being called in execute command activity . But it is not allowing to have a parameter in the command option. Is there any other alternative for it making it a variable ? Ex : /home/dsadm/test_script.sh to #SCRIPT_DIR#test_script.sh Hi, I dont think ...
- Mon May 18, 2009 3:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to remove all duplicate records
- Replies: 4
- Views: 2152
Re: how to remove all duplicate records
In this example, Col1 and Col2 are the key for removing duplicates. I want to remove both the records having duplicate values for these columns. Can it be implemented in DS or I need to write shell script for the same? Hi, This can be implemented in DataStage. First you need to get the count by gro...
- Fri May 15, 2009 1:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create the parallel routines for next day (Today+1Day)
- Replies: 2
- Views: 1978
Re: create the parallel routines for next day (Today+1Day)
Hi All, I have to create the parallel routines for next day (Today+1Day) Please any one can help me on how to create the routine. Thanks Vinod There are lot of posts here that tell you the steps on how to create a parallel routine. A search will help a lot. If I Understand the problem correctly, yo...
- Fri May 15, 2009 1:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: record not in output
- Replies: 3
- Views: 2055
- Fri May 15, 2009 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: record not in output
- Replies: 3
- Views: 2055
Re: record not in output
when i check the monitor it shows that the output is coming out of aggregator 2, but as the input of join1. in the log it is not showing anything that it is dropped. Hi, can you explain more clearly the quoted sentence. Also, check if you have any warnings in the log. Cant help much as the problem ...
- Wed May 13, 2009 2:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Parameterize Invocation ID
- Replies: 10
- Views: 9460
Thanks for your reply. Iam aware of that option, but my requirment is to parametarize it. Please let me know how can this be achieved. Regards, Rajendhar You can use the job parameter of the sequence and use it for Invocation id. or You can also create User variables and use it for Invocation Id in...
- Wed May 13, 2009 1:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get reject record
- Replies: 2
- Views: 1859
Re: To get reject record
there is only one column 2 value for BB record in the lookup file,i need to assign the value for one record , so another record in input file needs to send as reject record. . Hi, If I understand your post correctly, You problem is more related to rejection of duplicates, rather than with the looku...
- Wed May 13, 2009 1:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Parameterize Invocation ID
- Replies: 10
- Views: 9460
Re: How to Parameterize Invocation ID
Hi Rajendhar
If you observer the JobActivity Stage in the sequence, you will find an option called InvocationID. here you can give mention the same, instead of providing the value at run time.
If you observer the JobActivity Stage in the sequence, you will find an option called InvocationID. here you can give mention the same, instead of providing the value at run time.
- Tue May 12, 2009 2:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: jpfile non-existent
- Replies: 7
- Views: 3520
- Tue May 12, 2009 2:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Rotine Activity triggers
- Replies: 2
- Views: 2219
Re: Rotine Activity triggers
When text file has empty data it is directly going to Terminate stage but it is supposed to go to success link. How can I write a expression to read the empty data. Return values 1) = ' ' 2) =" " 3) =@NULL Can you do some check whether the problem is while reading the empty file or with t...
- Thu May 07, 2009 4:12 am
- Forum: General
- Topic: Datastage certification cost
- Replies: 12
- Views: 14903
Re: Datastage certification cost
The certification cost for --- Test 415 - IBM WebSphere IIS DataStage Enterprise Edition v7.5 is 3750 rs[/b] Hi, The latest and correct information is available through prometric testing website or the IBM website. The exam fees for 000-415 is 100 US$ and you need to calculate as per the exchange r...
- Wed Apr 29, 2009 12:43 am
- Forum: General
- Topic: Basic questions
- Replies: 3
- Views: 2440
Re: Basic questions
1) Is there any command to know/get the datastage version? 2) What is the new features of Datastage 7? ( i.e From a developer Perspective) 2) What is the new features of Datastage 8? ( i.e From a developer Perspective) 3) What is the limitations of Datastage 7? ( i.e From a developer Perspective) 4...
- Wed Apr 29, 2009 12:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filter stage fatal error
- Replies: 1
- Views: 1571
Re: Filter stage fatal error
How are you filtering the records in the stage.prams wrote:In one of my job i am using the filler stage to filter the rows based on the charater value.
What is the syntax you have used?
There could be some problem with that.