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.
>>