Make vector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
DINAKAR
Participant
Posts: 8
Joined: Fri Aug 08, 2008 11:45 am
Location: pune

Make vector stage

Post by DINAKAR »

Hi,

I am new to datastage, earlier worked on other ETL tools,

I was going through vector concept in datastage ( using parallel vesion 8.0), while reading through parallel job development guide came across Make vector stage, gone through description as well as example.

Question here is, how do I use the vector built by this stage, I mean once the single column col with vector comes out of this stage how can I use it in downstream process, Can I access perticular element, do mathematical cals or apply some in built function? How do I access array using perticular index, How do I loop through array elements?

Appreciate your resposne.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's not that kind of vector.

It's a structure that might be produced or consumed by a COBOL file definition containing a single field that OCCURS multiple times. Both fixed-count (OCCURS N TIMES) and variable-count (OCCURS MAX N TIMES DEPENDING ON fieldname) vectors are supported, though there are some restrictions on the latter.

You access vector elements using a standard index notation, which is fully described in the DataStage Parallel Job Developer's Guide manual.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply