Re: Blank table name
Raj,
[Quoted document follows.]
This solution can be implemented, but BEWARE, updating any sys* tables
requires a lot of ATTENTION.
You can become user informix and
update systables set tabname = "nullname" where tabid = 925
Then you can drop table nullname.
Again, playing around with systables is not encouraged, except for
extreme circumstances.
Catalin
--
=========================================================================
Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/
_/ _/ _/ _/ _/_/ _/
Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/
_/ _/ _/ _/ _/ _/
Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/
===== cat@tecsys.com =========== include system "disclaimer.4gh" =====
===== Home Page at http://www.virtualmarketplace.com/it/TECSYSE =======
Raj Manohar <raj@gtetel.com> wrote:
>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
>