Re: Using DBINFO

Colin Dawson wrote: > If I run the following > > select tabid, tabname, hex(partnum) > from systables > where tabtype = 'T' > order by 1> > I get a nice list of all tables and their respective partnum ordered by > tabid > > If I run the same query with , DBINFO('DBSPACE',partnum) added to the > list of columns, > I get 727: Invalid or NULL TBLspace number given to dbinfo(dbspace). > > If I do the same on a different DB on the same server it works perfectly > > > Anybody got any clues? > > > > Regards > > Colin Dawson > > > sending to informix-list > you have fragmented tables, or tables with detached indexes -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm sending to informix-list