How can one get teh columns headers (names) in sybase IQ extraction

[Former Member]

The following when run with dbisql produces the desired results:

select* from sysobjects;

OUTPUT TO 111 FORMAT ASCII QUOTE ''DELIMITED BY '|'

But if I want to have the column name on the top of the results, what should be done?

[Gisung]

Hi,

Try to test with the following query.

select* from sysobjects;

OUTPUT TO 111 FORMAT ASCII QUOTE ''DELIMITED BY '|' WITH COLUMN NAMES;

Best Regards,
Gi-Sung Jang