Re: dbaccess
The issue is thet the tabname column is 128 characters and that fills up the
row, dbaccess switches to 1 column per row format.
Instead of doing select *, just select the columns you really want to see
but truncate the tabname column to 18 or 20 characters.
"Mitja Udovc" <mitja.udovc@zrs-tk.si> wrote in message
news:bgsv7d$daf$1@planja.arnes.si...
> 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
>
> tabname pcr_sled_last
> owner informix
> partnum 1048706
> tabid 139
> rowsize 34
> ncols 7
> nindexes 4
> nrows 1765067
> created 03-08-05
> version 9633794
> tabtype T
> locklevel R
> npused 33304
> fextsize 100000
> nextsize 100000
> flags 0
> site
> dbname
> type_xid 0
> am_id 0
> .
> .
> .
> .
> .
>
>
> 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?
>
>