Re: Blank table name

In article <40amsb$bpq@txirvuhw302.gtetel.com> raj@gtetel.com "Raj Manohar" writes: > when i try it with with one of our databases, it crashes immediately. > The resolution form the vendor is to look for a table with blank > name and we did a find one. > > The command i ran is > > echo "select tabid,tabname,owner from systables where systables.tabid \\ > >= \\"100\\""|isql arsystem > > we got all the tables listed and this one did not have a name but > a tabid and owner > 924 sh_schema01 root > 925 root <this is the one> Delete all the rows from systables (& other system catalogues) where 'tabid = 925'. This may work! Also (if you are using SE) you may like to 'bcheck' all the system catalogues. NB: System Catalogues: Tables where tabid < 100 Tables which contain the database of the database! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================