is there sys table where index names kept

Posted in 2013

Topics: Versions, Editions & End-of-Life

KARL OLIVER — Mon, 23 Sep 2013 01:59:01 — source: IIUG Forums & Mailing Lists

IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number AAA#B00000 is there are table where index names are kept. in the sysmaster db or anywjhere else

↪ replying to KARL OLIVER

Art Kagel — Mon, 23 Sep 2013 03:42:08 — source: IIUG Forums & Mailing Lists

Index details are kept in the sysindices catalog table in each database. There is also a view (sysindexes) which is easier to parse for simple indexes (ie not functional indexes). The index name is in the idxname column. For full details of decoding sysindices directly take at look at the file print_indexes.ec in the source code for myschema which is part of my package utils2_ak from the IIUG Software Repository. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Sep 22, 2013 at 9:59 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number > AAA#B00000 > > is there are table where index names are kept. in the sysmaster db or > anywjhere else > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34e6ca73f0a04e704cd07

↪ replying to KARL OLIVER

Lloyd S — Tue, 24 Sep 2013 00:50:00 — source: IIUG Forums & Mailing Lists

Karl, sysindexes table within your database. select idxname, owner from sysindexes Regards,Lloyd From: "KARL OLIVER" <karl.oliver@maf.govt.nz> Sent: Mon, 23 Sep 2013 07:29:26 To: ids@iiug.org Subject: is there sys table where index names kept [31475] IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number AAA#B00000 is there are table where index names are kept. in the sysmaster db or anywjhere else *******************************************************************************  Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Lloyd S

KARL OLIVER — Tue, 24 Sep 2013 23:50:23 — source: IIUG Forums & Mailing Lists

thanks for infor guys