Hi All,

Attunity has a datasource by the name "TEST"which contains the Archive files(IBM OPTIM).I have created a linked server(sql server 2008) pointing to attunity using ATTUNITY ODBC with passthru enabled.When i run regular such as
select*fromopenquery(QASAP_ARCCOL,'SELECT * FROM TABLENAME');
every thing works fine but when i want to execute the following query

select*fromopenquery(QASAP_ARCCOL,'list tables');
it fails with an error message.


I some how need a way to list all the tables in a datasource(attunity) using the openquery.
Please let me know your thoughts.
Thanks........