Instead of building code from an open record set for output
to a CSV file format I am trying to EXECUTE an SQL statement
using built in. I just tried to use to test in dbisql
select * from incidents;
OUTPUT TO test.txt
FORMAT EXCEL

Says Excel is invalid. I tried XML, and HTML with same
results. What am I missing? My version is 8.0.3:5002
Windows

Funny, since it works for me with 8.0.3#5576 and
I have no recollection of that being broken in any
8.0.x release.

I do get an Invalid Format error if I use the dbisqlC
utility (provided mostly for backward compatability)
and that may be your issue. Using the Java one instead
would remedy that.



"clayton" wrote in message news:4b0c8c87.3c69.1681692777 (AT) sybase (DOT) com...

You could try this:

select *
from SomeTableName;
output to c:\AnyFileName.xls format html;
commit;

Open the file using Excel and it will work.

Best regards,
Rachan Terrell


<clayton> wrote