[unixODBC-support] ISQL Question

Martin J. Evans bohica at ntlworld.com
Fri Jun 17 17:00:22 BST 2011


On 17 June 2011 16:02, Hall Johnson, Patti <Patti.Hall.Johnson at nytssc.com>wrote:

>  Is there a way in ISQL to not display the blocks around the results
> returned from the select and the rows selected?****
>
> ** **
>
> +------------+****
>
> |                  |****
>
> +------------+****
>
> | 4               |****
>
> +------------+****
>
> SQLRowCount returns 1****
>
> 1 rows fetched****
>
> ** **
>
> ** **
>
> I would like to just have returned this:  4****
>
> ** **
>
> Thanks.****
>
> ** **
>
>
The closest I know is something like  -x0x09 - see man isql.

SQL> select * from mje;
1    fred
1    fred
1    fred

However, isql is a very simple program and should be relatively easy to
change the output to whatever you want (if you know C). If you don't and -x
doesn't quite get you there a simple awk/perl filter could easily remove
whatever is left you don't need.

Martin
-- 
Martin J. Evans
Wetherby, UK
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110617/6adbf3d8/attachment.html>


More information about the unixODBC-support mailing list