DSXchange

Try changing the type to Continuous Funnel. This may give you the desired output.

You can use the Funnel stage in Parallel jobs to achieve this.

My question again was: Is there a way to poll for a table value from datastage...and keep polling until a particular column value is found...then trigger the sequencer from then on... This seems like a simple thing (If I am not missing any major details). Pre-requisite: A row in table 'X' gets upda...

Thanks for the help all. @OddJob: I tried that too. But it doesn't work for 7.5x2 or 8.x @Craig: I guess the problem is a "Windows only" thing. I'll create a ticket with IBM and see how it goes from there. If somebody finds a way to do this on Windows, please put it on this post. Thank you...

minhajuddin - you never answered on whether the eCase was "fixed" or not. @ArndW: Thanks for the help, I don't know if this Ecase has been solved. But, I guess it would be the same with other installations as well. And fortunately we have another server with DS 8.x on it. And when I teste...

minhajuddin - you never answered on whether the eCase was "fixed" or not. @ArndW: Thanks for the help, I don't know if this Ecase has been solved. But, I guess it would be the same with other installations as well. And fortunately we have another server with DS 8.x on it. And when I teste...

Tried the following things, But with no success, the first line is the job paramter being passed. The lines after that are directly taken from the target file, for a input job parameters I got a newlines after each line of target data. ----------------------------- job_param=single\'quote single\quo...

What is the ACTUAL PARAMRETER value that you are trying to pass? I am trying to pass the whole query through a job parameter So you've tried passing \' for each single quote and it didn't work for you? What about making each single quote a pair of single quotes? Code: select EMP_ID, EMP_NAME, to_ch...

Alright, so, does that mean nobody ever needed to pass a single quote in their job parameters? If so, did you guys find a workaround? I need to pass an SQL Query using job parameters and some of the queries have the timestamp masks in them. #sql_query#==> select EMP_ID, EMP_NAME, to_char(TIMESTAMP, ...

This time I tried something different. My jobX: Row_Generator=======> Transformer ========> Sequential File (Generate 10 (Adds a column dummy rows) with the value from job parameter) First I created a sequence and added the jobX to it. I hardcoded the value of the job in the sequence as char(039), A...

You should be reading your source file as DOS formatted file. If you are already doing that, you better check by dumping the data into another flat file (Replace the db by a sequential file, and set the file to be created in Unix format). Now, check your file again in a Hex editor, Do you see the xO...

Does your PATH environment variable point to the MKSToolkit bin?
if not, you should add it to the path.

And by the by, there is a difference between 7.5 and 7.5x2.

then you would have to use and check the output of this in a downstream Nested condition activity. Trigger the join job only if the count is > 1.

No. SQL is always sequential unless selecting from a partitioned table. I believe (without proof) that user-defined SQL is always sequential. ... Is this specific to DB2? Because I have seen jobs with user-defined SQL run in Parallel mode when a Partition table property is added in case of Oracle E...

In the sequence which controls the job which has your join, Do this: >> Add an execute command stage and run the command test -s <file_name> in that command by pointing it to the file which is expected to be empty. >>Add a Nested Condition activity and use a custom trigger which triggers the job wit...