On 7/6/06, Quman <yquman@gmail.com> wrote:
> I just installed IDS 10 UC4 . Every thing looks fine.

ON what sort of machine? Running which O/S and version?
Please note that the version is 10.00.UC4.

> But it only displays the following one line when I run " info columns
> for table xyz"
>
> Column name Type
> Nulls
>
> What's wrong?

Does table xyz exist? Is it just table xyz or is it every and any
table? Did you create xyz in this database with this version of IDS,
or was it migrated forwards from some older version of IDS?

Assuming xyz exists (and it shouldn't matter which version of IDS
created it) and assuming that similar behaviour is shown for all
tables, then there appears to be a bug in DB-Access. There are a
variety of ways to demonstrate whether this is the problem. Maybe the
one to use this time is to run SET EXPLAIN ON before executing "INFO
COLUMNS FOR TABLE xyz", and then looking at the SQL in the
sqexplain.out file to see what it is that DB-Access is doing.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/