Blank table name
Posted in 1995
Topics: Installation, Setup & Upgrades, Server Administration, Migration, Import/Export & Data Conversion
Hi:
I am not a DBA, so my apologies if this is a naive question.
we have installed "iqx" a software which runs against informix data
base and helps us in charting and graphing.
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>
............
I called Informix and the only solution that they have is to
create a dbschema of the database, dbexport it, drop it, clean up
the dbexport file and recreate it without the table.
Any other simple suggestion?
I would appreciate if you could e-mail yr replies to
raj@gtetel.com
Thanks
--
Raj Manohar
GTE Telephone Operations
raj@gtetel.com