Fragmented tables

Hi, Is there a way (a sql script maybe) that would create a list of all tables in a database that are fragmented and what fragmentation expression was used without going through dbaccess,table,info,fragment menu? I can do this using dbschema on a specific table but only for those tables I know that got fragmented. Would appreciate any assistance on this. Thank you

Any table with tabtype 'T' and a zero partnum in systables is a fragmented table. The fragmentation scheme is stored 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, Aug 30, 2012 at 3:01 PM, JOSE STA. CRUZ <joeystacruz@hotmail.com>wrote: > Hi, > > Is there a way (a sql script maybe) that would create a list of all tables > in > a database that are fragmented and what fragmentation expression was used > without going through dbaccess,table,info,fragment menu? > > I can do this using dbschema on a specific table but only for those tables > I > know that got fragmented. > > Would appreciate any assistance on this. > Thank you > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f502e0ccc5cd204c8805e9a

Thanks Art, I really appreciate your response.