Re: Determining version dynamically
Bjarne W. Jensen suggested select DBINFO('version','full') from systables where tabid = 1 to get the server version dynamically. Art S. Kagel replied it does not work in 5.x, 6.0x, 7.1x or 7.2x. John Carlson confirmed it works in 7.30.UC7 with sysmaster or a user database. Art clarified that it only works from 7.3x onward.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO. Bjarne W. Jensen Alm. Brand Denmark
bjarne.wilken.jensen@almbrand.dk wrote: > > Hi, > > If you have Informix Dynamic Server then use the following sql-statement > ' select DBINFO('version', 'full') from systables where tabid = 1' > > result from the sql is : > Informix Dynamic Server Version 7.30.UC5 > > Take a look in Informix Guide to SQL: Syntax for more about DBINFO. Nope. Does not work in 5.xx, 6.0x, 7.1x, or 7.2x. Probably not in 8.xx or 9.1x either though I cannot check that out! Art S. Kagel
Works in 7.30.UC7 using either sysmaster or user-defined database. John Carlson Informix DBA WHSmith USA Art S. Kagel wrote: > > bjarne.wilken.jensen@almbrand.dk wrote: > > > > Hi, > > > > If you have Informix Dynamic Server then use the following sql-statement > > ' select DBINFO('version', 'full') from systables where tabid = 1' > > > > result from the sql is : > > Informix Dynamic Server Version 7.30.UC5 > > > > Take a look in Informix Guide to SQL: Syntax for more about DBINFO. > > Nope. Does not work in 5.xx, 6.0x, 7.1x, or 7.2x. Probably not in 8.xx > or 9.1x either though I cannot check that out! > > Art S. Kagel
"Carlson@WHSmith" wrote: > > Works in 7.30.UC7 using either sysmaster or user-defined database. > > John Carlson > Informix DBA > WHSmith USA > > Art S. Kagel wrote: > > > > bjarne.wilken.jensen@almbrand.dk wrote: > > > > > > Hi, > > > > > > If you have Informix Dynamic Server then use the following sql-statement > > > ' select DBINFO('version', 'full') from systables where tabid = 1' > > > > > > result from the sql is : > > > Informix Dynamic Server Version 7.30.UC5 > > > > > > Take a look in Informix Guide to SQL: Syntax for more about DBINFO. > > > > Nope. Does not work in 5.xx, 6.0x, 7.1x, or 7.2x. Probably not in 8.xx > > or 9.1x either though I cannot check that out! Right. My point was that it did not work BEFORE 7.3x. Art S. Kagel