Re: Dbaccess output formatting
Frank Dickinson wrote:
>
> Can anyone point me in the right direction on how to control the
> output of dbaccess. Sometimes it produces output that is
> presented accross the page, other times it produces output down
> the page. What logic is it following?
It's based on the width of the screen. As soon as a horizontal format no
longer fits, it reverts to a vertical format.
If you have very long column names then you can alter this effect by giving
these columns alias names, such as:
SELECT a_very_long_name avln, nother_v_long_name nvln
FROM table
If you have very long character fields, you can truncate them using the
substring syntax:
SELECT long_char[1,20], nother_long_char[1,5]
FROM table
And of course you can combine the two.
Hope that helps,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+