Advantage Data Architect doesn't accept 'output to', are there any other options for outputting a table to a file?

Question

I'm trying to output the results of a SELECT query to a tab delimited text file in Advantage Data Architect. I know I can use the 'Export to' feature to do this, but there are a lot of tables and that is going to take forever. I would rather use the SQL editor, but I found out it does not accept the OUTPUT TO argument, even though that command is part of Sybase SQL.

I would like to do this:

SELECT * FROM tablename;
OUTPUT TO 'C:/ExportDirectory' DELIMITED BY '\t' FORMAT TEXT;

Is there another way?

Answer 1

Maybe someone else knows a clever way to do this, but I don't think this functionality exists natively in the Advantage SQL engine. If you are Delphi developer, one possibility comes to mind. The Advantage Data Architect ships with the source. The file texttable.pas has the bulk of the logic that writes the text file for the export functionality you mentioned.