DSXchange

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...

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?

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 ...

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...

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...

Hi,
can you explain what are the columns that you are using to join the two inputs ?
Are there any matching records in your two sources to start with ?

Instead of seeing the director, please tell us your problem in terms of logic rather than the record count.

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 ...

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...

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...

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.

anandsiva wrote:Its a datastage internal file. I don't know much details of this file. My job got aborted with that error.

Hi,
I havent come across any internal file with such name.
Anyway, can you post details about your job and also the complete error message from the log?

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...

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...

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...

prams wrote:In one of my job i am using the filler stage to filter the rows based on the charater value.

How are you filtering the records in the stage.
What is the syntax you have used?
There could be some problem with that.