[unixODBC-support] unixODBC 2.2.12 - isql - how to disable column headings in output?

Leland Flox Leland.Flox at safeguardproperties.com
Thu Jul 26 14:11:54 BST 2007


Is there a way to disable the column headings and row count output from
isql?  Only the data / rows should be displayed.

 

-- Leland

 

 

$ isql mydsn myuser mypasswd -b < mysql.sql

+-------------+--------------+---------------------+-------------+------
----------+-----------------------------------------+-------------------
----------------------+-----------------------------------------+-------
--------+-------------------------+---------------------+---------------
--------------------------+---------------------+---------------------+-
--------------------+---------------------+

| Customer No_| Document Type| Document No_        | Ship-to Code| Loan
Number    | Inv Amt                                 | Pmt Amt
| Adj Amt                                 | Department| Posting Date
| Order Number        | Disputed Amount                         |
Applies-to Doc_ Type| Applies-to Doc_ No_ | Entry No_           | Entry
Line No_      |

+-------------+--------------+---------------------+-------------+------
----------+-----------------------------------------+-------------------
----------------------+-----------------------------------------+-------
--------+-------------------------+---------------------+---------------
--------------------------+---------------------+---------------------+-
--------------------+---------------------+

| xxxxxx      | 2            | 2379724             | FORC        |
6003063935     | 35.000000000000                         |
0.000000000000                          | 0.000000000000
| 2             | 2003-11-12 00:00:00.000 | 111111            |
0.000000000000                          | 2                   | 2379724
| 2144172             | 0                   |

| xxxxxx      | 1            | 457569              | FORC        |
6003063935     | 0.000000000000                          |
-35.000000000000                        | 0.000000000000
| 2             | 2004-02-10 00:00:00.000 | 111111            |
0.000000000000                          | 2                   | 2379724
| 2214900             | 0                   |

+-------------+--------------+---------------------+-------------+------
----------+-----------------------------------------+-------------------
----------------------+-----------------------------------------+-------
--------+-------------------------+---------------------+---------------
--------------------------+---------------------+---------------------+-
--------------------+---------------------+

SQLRowCount returns 2

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20070726/56fb3840/attachment.html>


More information about the unixODBC-support mailing list