George ....

I used to (on unix platforms) do something like this ...

select 'XXX'||field_1, field_2 ....
from table;

Then I would pipe that through grep and sed to select only data lines
and get rid of the 'XXX' token.

Now I use perl and the IB module ...

hth
bill

Yolland, George wrote:

>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@...>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>