Re: Determining version dynamically

Posted in 1999

bjarne.wilken.jensen@almbrand.dk — Wed, 11 Aug 1999 12:34:08 +0100 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to bjarne.wilken.jensen@almbrand.dk

Art S. Kagel — Wed, 11 Aug 1999 10:17:27 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Art S. Kagel

Carlson@WHSmith — Wed, 11 Aug 1999 10:54:45 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Carlson@WHSmith

Art S. Kagel — Wed, 11 Aug 1999 15:03:36 -0400 — source: Informix-list mailing list archive (1991-1998)

"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