Advantage Data Architect doesn't accept 'output to', are there any other options for outputting a ta
- by likesalmon
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?