SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:30 AM
| ||||
| ||||
 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/      |
|
04-20-2008, 11:30 AM
| |||
| |||
| Re: info columns Jonathan I am glad some other person using dbaccess ran into this beside me. I to used used the old syntax of: "info columns for table XYZ" This syntax was removed in version 10 because it is not documented. The documented syntax is "info columns for XYZ" The keyword table is ommitted. I had entered this as a bug 170890 bug it was closed as not a bug because it is unsupported syntax. John Jonathan Leffler wrote: > 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. > |
|
04-20-2008, 11:31 AM
| ||||
| ||||
| Re: info columns John Miller wrote: > Jonathan > > > I am glad some other person using dbaccess ran into this beside > me. I to used used the old syntax of: > "info columns for table XYZ" > This syntax was removed in version 10 because it is not documented. > The documented syntax is > "info columns for XYZ" > The keyword table is ommitted. > > I had entered this as a bug 170890 bug it was closed as not a > bug because it is unsupported syntax. Unsupported, but existing syntax? Not in 7.31! IDS 7.31 dbaccess says: > info columns for table message_header; 839: Table not found. Error in line 1 Near character position 1 I'd reopen the bug report, unless this unsupported syntax was added in 9.xx sometime and I never noticed. Art S. Kagel > John > > > > Jonathan Leffler wrote: > >> 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. >> |
Linear Mode
