[unixODBC-support] ISQL Question

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


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

>  Thank you Martin for the reply.  I just realized that I don’t have man
> pages setup for isql.  I’ve got to figure that out next.  ****
>
> **
>

run isql -h and it will give you pretty much the man page.

Martin

**
>
> ** **
>
> *From:* unixodbc-support-bounces at mailman.unixodbc.org [mailto:
> unixodbc-support-bounces at mailman.unixodbc.org] *On Behalf Of *Martin J.
> Evans
> *Sent:* Friday, June 17, 2011 12:00 PM
> *To:* Support for the unixODBC project
> *Subject:* Re: [unixODBC-support] ISQL Question****
>
> ** **
>
> ** **
>
> 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/96027f19/attachment.html>


More information about the unixODBC-support mailing list