Advantage Data Architect doesn't accept 'output to', are there any other options for outputting a ta
Posted
by likesalmon
on Stack Overflow
See other posts from Stack Overflow
or by likesalmon
Published on 2010-04-28T22:51:30Z
Indexed on
2010/04/28
22:57 UTC
Read the original article
Hit count: 263
sybase
|advantage-database-server
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?
© Stack Overflow or respective owner
