> how can I get the indexes of some or all tables in a database using
> DBI driver? I'm using the Informix-DBD, and there's no hint about this
Your best bet is probably to go to the IIUG software archives
(hmm, how many times have I said this today? http://www.iiug.org)
and get hold of SQLCMD. In the code for the INFO statements
(sqlinfo.ec), you will find the statements I use to generate the
information loosely equivalent to "INFO INDEXES FOR sometable",
which is not a built-in command in SQL so you cannot run it
directly from DBD::Informix. Note that the statements assume
you know the table number (systables.tabid) entry for the table.
To deal with lists of tables, you will have to revise the code
Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
"I don't suffer from insanity; I enjoy every minute of it!"