Re: info columns
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/ _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
The syntax is INFO COLUMNS for <tablename> Kannan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Le.... Sent: Friday, July 07, 2006 12:33 AM To: ids@iiug.org Subject: Re: info columns [7089] 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/ _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.