Re: DBSCHEMA doesn't show the DBSPACE????

Another way of seeing the dbspace a table was created in is - select dbinfo("dbspace", partnum) from systables where tabname = "<tabname>" ...and yes, Neil is right, the dbschema -ss will only show the dbspaces for the tables not created in the same dbspace your database was created in. Regards Dirk roger.bruening@metrokc.gov wrote in article <6u8jbq$22k$1@nnrp1.dejanews.com>... > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. All others > I simply have to guess (look at documentation). > > My syntax is dbcshema -d database -t tablename -ss > > The only way I can get space info then is using oncheck -pe and then > searching thru the output file for the table. > > So, If I need to drop and recreate tables etc, I will have to modify a > schema file for each table to put it in the proper space. > > Is there a better way?? (running 7.24 on DEC Alpha) > > TIA Roger Bruening > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum >