Basic for-next loop in TDV

[Paul Hammond]

I would like to see if someone has a basic for-next loop query for Tibco Data Virtualization.

[Svein Opsahl]

Is this what you mean

 

procedure basicForLoop()

begin

declare tables cursor for

select schema_name, table_name

from /services/databases/system/ALL_TABLES

where schema_name is not null

and table_name is not null;

 

for tab as tables do

call print(tab.schema_name || '.' || tab.table_name);

end for;

end

[Jeremy Akers 2]

There are also several examples in the documentation. If you simply click Help -> Online Help in Studio, and do a search for "loop" you'll find tons of documentation and examples of the various kinds of loops available in TDV SQL Script.

[Deepak Kuletha]

Correct