Retrieve SQL Statement from VARA object

[Ken Yong]

Dear guys,

I have this SQL VARA object as shown below.

May I know if there is any way I can use a script (Which script element) from another object to retrieve the "SQL statement" query from this SQL VARA object? 

Thank you! 

------------------------------
Ken
TX, Houston
------------------------------

[Pete Wirfs]

I think that data is stored in the OVD table, column OVD_SQL.  You could construct a SQLI variable that would retrieve it.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Ken Yong]

It works! Thank you Pete!

------------------------------
Ken
TX, Houston
------------------------------