DSXchange

My apologies for giving the wrong solution

If you have more than one column and you want other columns to be intact, you need to split it using a copy stage aggregate it on COL1 and then join it back with the original stream on COL1

These work even from the server :D

Only if the server has a Windows OS and has Datastage client installed on it

Some math for DSXChanger's

You can try changing the datatype in the oracle stage to a varchar and pass an empty string for NULLs.

As far as I know dscmdimport.exe and dscmdexport.exe are "Client utilities". So, the OS of the server shouldn't matter at all. Why don't you just try it out and let us know if you face any issues.

The only thing that comes to my mind is a parallel routine. You can do this by creating a simple parallel routine.

An aggregator can do aggregation using two methods: Hash: This method is best for a small amount of unique "group by" keys (<10000) Sort: This method would work best for aggregating data which has a large amount of unique "group by" keys. If you use this stage the data has to be ...

Convert(Right(DSLink3.Amount,1),t,DSLink3.Amount)

Is 't' a stageVariable in your transformer? If not, it has to be a string which is supposed to be enclosed in two single quotes. By the by, is your error a compile time error?

Just to figure out where the problem is:

echo J1.$UserStatus using an execute command activity and see if you are user status is being set correctly in job J1

Hey Craig, I meant no offense. I respect you a LOT. I guess there is just a misunderstanding about the requirement.

Nice picture by the by :D

But i feel that this suggestion would result, 1. Unwanted creation of datasets. (in every run two unwanted datasets) 2. Unwanted execution of the rest of the Jobs. I suppose that chulett had given enough solution for this problem. I don't know about others, But, If I find a simple way to solve a pr...

Udankar, You would find a lot of posts which discuss this, Search the forum for them.

Here is my requirement : I have a sequence MySeq that has job J1. Now J1 produces N records (each containing say 5 columns) Now based on each record column value, I need to call different jobs say J2,J3 etc in the sequence MySeq. How to impplement that. This seems simple to me, I hope I am not miss...

Well, there is no "stage" in Datastage which does this automatically. You may have create a Custom stage for this purpose. Or you can do it by creating a Parallel routine, which will do this for you.