Re: Oracle Command Equivelent

Mea culpa. Sorry. On 7/3/06, Jonathan Leffler <jleffler@earthlink.net> wrote: > Tam OShanter wrote: > > Struggling to find a command similar to DESC in Oracle and sp_help in SQL > > Server/Adaptive Server for Informix. > > > > I've seen mention of INFO TABLE but cannot seem to get it to work. > > Typing INFO TBALE FOR <tablename> produces syntax errors when I try > > to use it. > > Which bit of the manual did you look in? > > Even assuming you wrote TABLE instead of TBALE, you need to discover > that the syntax is: > > INFO TABLES; > INFO COLUMNS FOR TABLE xyz; > INFO INDEXES FOR TABLE xyz; > ... As John Miller pointed out, I can't read the manual accurately. The correct syntax is: INFO COLUMNS FOR <table>; The reported behaviour - that DB-Access pretends to execute INFO COLUMNS FOR TABLE tablename - and does not generate an error is incorrect. It should reject the statement with a syntax error. > If you look up the INFO statement in the SQL Syntax manual, you find ...that I can't transcribe. But that doesn't exempt others from reading the manual either. > all this, and more. The statement only works in DB-Access - it is not > understood by IDS. DB-Access interprets it, and decides which query or > queries to generate and then formats the results. [...] -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/