Re: dbaccess
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