Need help on 'Make Vector' Stage

[jayakrishna.koganti]

Hi All,

Iam new to the DataStage,I need a help on 'Make Vector' stage.
Basically it'll converts rows to columns.
Till now we written a query in DB2 stage to convert rows to
columns. But client asking to use a stage instead of writing a huge
query.
But evey one saying to use Pivot stage.It's not helpful
Can any one pls help ASP

Thanks,
jayakrishna

[ray.wurlod]

Welcome aboard.

As a matter of principle we resent "ASP" requests. DSXchange is an all-volunteer site whose participants post as and when they can. If you want urgent help, sign up with your support provider for premium service, and learn that there is a true cost associated with "urgent".

A vector is not multiple columns, a vector is contained in one column, so a Make Vector stage is probably not the solution you require.

You need to be more specific about your requirement in order to make a sensible choice of stage type. Meanwhile, having read the chapter in the Parallel Job Developer's Guide on the Make Vector stage, what is it from that that you don't understand?