Sorry... you can do that in dbaccess, unless you do some "trick"...

Instead why don't you use a SQL client like Winsql or IfxSQL.

Chucho!

-----Original Message-----
From: "Mitja Udovc" <mitja.udovc@zrs-tk.si>
To: informix-list@iiug.org
Date: Thu, 7 Aug 2003 09:32:25 +0200
Subject: dbaccess

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?




Jean Sagi
jeansagi@myrealbox.com
jeansagi@netscape.net


sending to informix-list