On Thu, 07 Aug 2003 03:32:25 -0400, Mitja Udovc wrote:

> When I make SELECT * from systables I get:
>
> tabname pcr_users
> owner informix
> partnum 1048702
> tabid 137
> rowsize 377
> ncols 10
> nindexes 2
> nrows 33
> created 03-07-02
> version 9043971
> tabtype T
> locklevel P
> npused 3
> fextsize 16
> nextsize 16
> flags 0
> site
> dbname
> type_xid 0
> am_id 0
<SNIP>
>
> I would like to have data presented in rows like that tabname owner
> partnum tabid .... pcr_sled_last informix
> ....
>
> When I have instead of * only two fields, then it is OK. Is there any
> way to solve this?

Ya, dbaccess will switch to that format if the output is >= 80 columns.
You have two good alternatives. First there are scripts on the IIUG
Software Repository to reformat the output, so you would output to disk
and run the scripts. Another as Paul mentioned is to get Jonathan
Leffler's latest sqlcmd package from the Repository. It can output in
several formats including UNLOAD, CSV, fixed field width, etc. These
formats are all much easier to reformat into whatever format you want.
Options are available to output column names and/or types both of which
are omitted by default.

Art S. Kagel