DEFAULT_ATTACH - IN TABLE clause

Hi, I have a 11.70 informix server that was upgraded with DEFAULT_ATTACH set to 1, so some index appears with IN TABLE clause when I run a dbschema. There's a query to show which indexes have the IN TABLE clause?

Attached indexes do not have an entry in sysfragments, any index with an explicit fragmentation clause or IN dbspace clause will have an entry in sysfragments. Art Art S. Kagel 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 Thu, Apr 4, 2013 at 3:55 PM, FELIPE CLEMENTE <felipe@mcsoftware.com.br>wrote: > Hi, > > I have a 11.70 informix server that was upgraded with DEFAULT_ATTACH set > to 1, > so some index appears with IN TABLE clause when I run a dbschema. There's a > query to show which indexes have the IN TABLE clause? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01161a9448e1a604d99040e6