Re: Finding version number of database server

Posted in 1997

Jonathan Leffler — 21 Aug 1997 20:08:12 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: nguyenv@cognos.com (Vinhson) >Date: 21 Aug 1997 22:27:48 GMT >X-Informix-List-Id: <news.41945> > >Does anyone know which system table(s) contains >the version number of a database server? [...] SysTables has an entry for the version number. The TabName column contains ' VERSION' (leading space significant!). The Owner column contains the version number: $ sqlcmd -d apt -e "SELECT TabName, Owner FROM SysTables WHERE TabName = ' VERSION'" VERSION|7.22C1 $ Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.