SQL Anywhere database - Output to fixed format column justification

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Output to fixed format column justification

mcdonnell1@cox.net

2005-05-18, 3:23 am

Hi,
We just upgraded to sql anywhere 8.0.2, (from I think version 5)and a
database event which calls dbisql.exe through "call xp_cmdshell"
doesn't justify the data columns correctly anymore. The sql statement
has not changed. It used to left justify the text, and right justify
the numbers. Now it left justifies everything. If I run the sql
statement directly through ISQL, the results pane seems to justify the
data "correctly" (left and right depending on data type), but when I
open the file that it creates, everything is left justified.

I saw a similar post from a couple years ago, (virtually identical
situation), but there did not appear to be a resolution.

Any ideas?

Thanks,
Ken

Sponsored Links