Subject Suppressing Column Heading in ISQL
Author Yolland, George
Hi,

I am using ISQL to extract some data from an application. The column
heading are inserted about every 20 rows of data like:

COL1 COL2 COL3 COL4
======================= ============ ========== ======

I would like to suppress these column headings in the output file.

I have looked at the documentation (IB v. 6 Operations Guide) and can't seem
to find a command or setting that will do this. I found by searching the IB
Phoenix website that I can set the page length using the -page option. I am
able to set the page length to something really long like 1000000 and this
suppress all but the first row. So is there a way to completely suppress the
column headings. I tried -page 0 ... didn't work.

FWIW, knowledge base record 171 indicates the page length option is
available in v 4 and v 5 but does not indicate it works in v 6 or Firebird
1.x. Can this KB record be updated to indicate this works in FB 1 and the
min and max value?

TIA, George

George Yolland Data Warehouse Programmer
Unisys Corporation voice: 480-783-5934
6161 West Erie Street fax: 480-783-5916
Chandler, AZ 85226 <mailto:george.yolland@...>