Query OUTPUT FORMAT TEXT

Former Member · ‎2011 Dec 20

One of our systems was using an older version of SQL Anywhere and when I would run a query with the FORMAT TEXT option like this

select * from tblmed; output to e:\\temp\\med.txt format text

I would get a fixed width file with headers and ------'s under the headers indicating the column width. I also wrote a script to use those output files in a custom reporting system.

After a recent upgrade that same query producing a comma separated file with no headers. Is there a way to get the old fixed with output back?

I know I can rewrite the script but I would like to avoid that if possible.

Thanks in advance,

Mike

Former Member · ‎2012 Jan 03

For DBISQL, the following command line will probably get you close:

select * from tblmed > e:\\temp\\med.txt

When run in a command window, DBISQL prints result sets to the console with column names and a long line of dashes as you described. I recognize that it does not achieve your goal of not having to change your script files.

johnsmirnios · ‎2011 Dec 20

Interesting... we had a request for that old format recently and issued a fix. If you're not the one who requested the fix, it's another case of the phenomenon where requests or bug reports tend to come in groups 🙂 Note that the fix below addresses dbisqlc -- I'm not sure what the java dbisql does.

SA Bug Fix: QTS 692617(OTW): fixed-width output with column headings was lost when ASCII renamed to TEXT

Versions Affected: 11.0.0.1150 and later
Modules Affected: dbisqlc

Fixed In: 11.0.1.2725, 12.0.1.3522

Description:

When we renamed 'ASCII' to 'TEXT' for the dbisqlc OUTPUT_FORMAT option, we lost the ability to generate the old format that dbisqlc called 'TEXT' which was fixed-width with column headers. Now, setting the OUTPUT_FORMAT to 'COLUMNS' will generate the old TEXT format.

Query OUTPUT FORMAT TEXT

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (2)

Answers (2)