How can I select the Database-Version ?

Hello, is it possible to retrieve the database-version via SELECT-statement ? Thanks Bernd

Brett Randall wrote: > > select owner > from systables > where tabname = " VERSION"> > ^ note space > > Bizarre, I know ... > > Brett Randall > > Bernd Steinhauer wrote: > > > Hello, > > > > is it possible to retrieve the database-version via SELECT-statement ? > > > > Thanks > > Bernd The problem doing this select is, that You get the version, which was used when the database was created. This may differ from the actual version, if You did an update in between. A far better seems to me to use an "dbaccess -V" instead -- ******************************************************************************* * Any opinions written in this e-mail are my own. They may not correspond to * * those of my company. * ******************************************************************************* * Wolfgang Zager Berghauser Str. 104 * * BAB Data-Systems GmbH D-42349 Wuppertal * * Abt. Programmierung Tel. : +49 202 479870 * * Fax : +49 202 470035 * * E-Mail: zager@gmx.de * *******************************************************************************

select owner from systables where tabname = " VERSION" ^ note space Bizarre, I know ... Brett Randall Bernd Steinhauer wrote: > Hello, > > is it possible to retrieve the database-version via SELECT-statement ? > > Thanks > Bernd

"Brett Randall" <Brett@reply.to.newsgroup> ... > select owner > from systables > where tabname = " VERSION"> > ^ note space > > Bizarre, I know ... Unfortunately this is a shortened version (without the F,U or T) and more the version number of the sysmaster database when it was *installed*. This is not necessarily the version you are running now after some db upgrades... Since 7.31 the dbinfo function can do the trick: SELECT DBINFO('version', 'full') FROM systables WHERE tabid = 1; For more options see the SQL syntax guide. > > Brett Randall > > Bernd Steinhauer wrote: > > > Hello, > > > > is it possible to retrieve the database-version via SELECT-statement ? > > > > Thanks > > Bernd > HTH Christian -- The opinions stated above are my own and not necessarily those of my employer.

Another one for the FAQ! Christian Knappke wrote in message <8ubiqc$2pj$1@news1.wdf.sap-ag.de>... > >"Brett Randall" <Brett@reply.to.newsgroup> ... >> select owner >> from systables >> where tabname = " VERSION">> >> ^ note space >> >> Bizarre, I know ... > >Unfortunately this is a shortened version (without the F,U or T) >and more the version number of the sysmaster database when it was >*installed*. This is not necessarily the version you are running >now after some db upgrades... > >Since 7.31 the dbinfo function can do the trick: > >SELECT DBINFO('version', 'full') FROM systables WHERE tabid = 1; > >For more options see the SQL syntax guide. > >> >> Brett Randall >> >> Bernd Steinhauer wrote: >> >> > Hello, >> > >> > is it possible to retrieve the database-version via SELECT-statement >? >> > >> > Thanks >> > Bernd >> > >HTH >Christian >-- > >The opinions stated above are my own >and not necessarily those of my employer. > >

Bernd Steinhauer wrote: > is it possible to retrieve the database-version via SELECT-statement ? According to the 9.20 Informix Guide to SQL: Syntax (6527.pdf from http://www.informix.com/answers), you can use: DBINFO('version', 'specifier') Where specifier can be one of: 'full' 'server-type' 'major' 'minor' 'os' 'level' On my 9.21.UC1 Foundation.2000 server, I get: select dbinfo('version', 'server-type'), dbinfo('version', 'major'), dbinfo('version', 'minor'), dbinfo('version', 'os'), dbinfo('version', 'level'), dbinfo('version', 'full') from systables where tabid = 1; Informix Dynamic Server 2000|9|21|U|C1|Informix Dynamic Server 2000 Version 9.21.UC1 Kinda useful, those manual thingies! :-) -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"