Re: How get Informix db server version through a SQL command?

Also, if you're using Informix on unix, simply type oninit -V at the command line to get the version number along with the serial #. But you probably already knew that and were just wondering how to do it via SQL. "Yarlagadda, Ravi" wrote: > The following SQL query provides to find out the IDS version. > > select * from systables where tabname = ' VERSION'> > Owner field contained IDS version. > > ----- > > Ravi Yarlagadda > > -----Original Message----- > From: Fabrice Lemay [mailto:"fabrice_lemay[NOSPAM]"@hotmail.com] > Sent: Monday, November 13, 2000 11:07 AM > To: informix-list@iiug.org > Subject: How get Informix db server version through a SQL command? > > Hi, > > Starting in using Informix db, I would like to know if there's a SQL > command which allow to get the db version? > Such command exist using Adaptive Server Anywhere from Sybase; it is : > "select @@version" > Is there an equivalent with Informix? > > Regards, > -- > Fabrice > (to reply, please remove the [NOSPAM] in my e-mail address) -- Phillip Tien Database Administrator Whole Foods Market, Inc. If I ever get rich, I hope I'm not real mean to poor people, like I am now.