Re: system catalog question

> > We're running Informix-SE version 4.00 on DEC station using Ultrix. We > currently have 3 databases running: one is live, one is static, and one is for > development. > > I'm writing a program that uses the system tables and I noticed that 2 of these > databases defines syscolauth.colauth to be char(3). All the manuals say that > this is to be a char(2) field. Does anyone have any ideas why we're getting > that extra character? Is this a bug or a feature? > In Informix 5.0 syscolauth.colauth is char(3), the third position being for reference privileges. systabauth.tabauth has also changed to char(8) for reference privileges. Once you run a 5.0 engine it makes the changes in the database. You can continue to use 4.0 with these databases. I don't know how the change could have happened, unless, could someone have run 5.0 at some time? ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Providing Informix Database Tools and Consulting # #############################################################################