Not straightforward, go to www.iiug.org and download SQLcmd by
the Jonathan Leffler

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
>
> 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?

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #