How to add rows dynamically to the VECTOR

[Madhavan Sekar]

Hi All,

I'm using TIBCO data virtualization v 8.2.0

How to add rows dynamically to the VECTOR

Code:

Step 1: DECLARE startPosVARCHAR;

Step 2: DECLARE testVector VECTOR(ROW(startValue VARCHAR,endValue VARCHAR,insideVector VECTOR(ROW (forName VARCHAR,forNumber VARCHAR))));

Step 3: SET startPos='0,1,2,3'; //this comma seperated value would increase or decrease

Step 4 : SET testVector = VECTOR[('','',VECTOR[('','')]),('','',VECTOR[('','')]),('','',VECTOR[('','')]),('','',VECTOR[('','')])];

The testVector is allowing to push data only if testVector is initialized (Step 4).Since data (Step 3) is dynamic ,The Vector to be made in such a way ot accepts data dynamically.

Kindly suggest a solution

Please refer theattached script