Re: Informix Online 5.x database identity

Mark D. Stock wrote: > > Malcolm Weallans wrote: > > > > Perhaps I can help June out on this one. The row id in tblsnum 1000002 > > is the entry in the OnLine pseudo table which keeps track of databases. > > If no databases have been deleted they should be in the order of > > creation, else you need to know many more specific details. > > That's true, but it has always made me smile. :-) Who knows which order > they created their databases in? Unless they only have a couple. ;-) > > Cheers, > -- > > Mark. > > +-------------------------------------------------------------------------+ > |Mark D. Stock - The West Solutions Group http://www.west.co.za | > | | > |mailto:marks@west.co.za +------------------------------------------------+ > |Tel: +27 11 803 2151 |If it doesn't work... force it! | > |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | > |Cell: +27 83 250 2325 |Well, that's how I code anyway! | > +------------------------+------------------------------------------------+ Hi, I think the only idiot who ever tried to create a table that looks like the internal database table was me. I created a table with the explained columns of the database tablespace, afterwards I've made an update of the partnum of my new table to 0x1000002. The result: I had a database table but the order of my columns was wrong. So I tried to alter the table and then,... well, I had no more problems, because all my databases had been gone. :-(( Now I know that it's not recommended to update the system tables. Hand off !!! Bye Stefan stefan@weideneder.de