TDV Build A list in Script

[Tyger Guzman 2]

Is it possible to build a comma separate string value in a script

 

PROCEDURE test()

BEGIN

declare x char;

declare tables cursor for Select

distinct col1

from /mypath/mytable;

for tab as tables do

x += tab.col1; --this does not work

end for;

call print(x);

END

[Deepak Kuletha]

Hi ,

 

Yes you can create comma separate string in a script , initially it can be achieved using vector concept in TDV.