Re: How do I get the version of Client and Server?
Here's a simple script I've made that displays all versions:
**********************************************
cd $INFORMIXDIR/etc
clear
cat *-cr |grep -v "Copyright"
**********************************************
it displays something similar to the following:
INFORMIX LIBASF LIBRARY Version 9.21.UC1
INFORMIX ODBC LIBRARY Version 3.30.0000.UC1
INFORMIX C++ API 2.61.UC1
INFORMIX-Client SDK Version 2.30.UC1
INFORMIX LIBDMI LIBRARY Version 2.11.UC1
INFORMIX EMBEDDED SQL for C Version 9.21.UC1
INFORMIX LIBGEN LIBRARY Version 9.21.UC1
INFORMIX LIBGLS LIBRARY Version 3.10.UC1
INFORMIX-4GL Interactive Debugger Version 7.20.UE1
INFORMIX-4GL Version 7.20.UE1
INFORMIX-4GL Rapid Development System Version 7.20.UE1
Informix Dynamic Server Version 7.31.UC5
INFORMIX-SQL Version 7.20.UE1
INFORMIX LIBOS LIBRARY Version 9.21.UC1
INFORMIX LIBSQL LIBRARY Version 9.21.UC1
Hope it's helpful.
Katwoman
Bill Border wrote:
> Hi All,
>
> I think that with most Informix executables you can run
>
> program -V
>
> ... and it will show the version. For example:
>
> dbaccess -V
> oninit -V
> onstat -V
> ...>
> Enjoy,
> Bill
> --
> Bill Border
> Agilent Technologies
> bb22@uswest.net
> Cool, affordable DB monitor: http://dbamon.com
>
> Art S. Kagel wrote in message <396F20B4.35977B39@bloomberg.net>...
> >abeylin@my-deja.com wrote:
> >>
> >> Hello everyone,
> >>
> >> Please let me know if it's possible to get the version of the client
> >> and/or server. I would like to be able to do this using a scripting
> >> language such as korn shell (running through MKS toolkit on a Windows
> >> platform).
> >> If you don't know how to get it using the scripting language, but know
> >> how to do it with C, please let me know.
> >
> >The server version you are connecting to is easy:
> >
> >Use dbaccess or sqlcmd in your script:
> >
> >dbaccess sysmaster - <<EOF
> >select DBINFO("version","major")||'.'||DBINFO("version","minor")
> >from systables where tabid = 1;
> >EOF
> >
> >Art S. Kagel