Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2008
    Posts
    18

    Unanswered: How to find informix version

    Hi ,

    I am a newbie and i would like to know how to find version number for informix across all versions,

    also on my instalation sys tables are not created, how to get arround it?

  2. #2
    Join Date
    Nov 2008
    Posts
    18
    SELECT owner FROM systables WHERE TABNAME= ' VERSION';
    owner 9.50C1


    From
    onstat -version
    Program Name: onstat
    Build Version: 10.00.UC5TL
    Build Number: N202
    Build Host: ibm6c1b
    Build OS: AIX 5.2
    Build Date: Thu May 18 00:09:08 CDT 2006
    GLS Version: glslib-4.00.UC8


    which one is correct?

  3. #3
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    9.50 equals 10.00
    9.51 equals 11.10
    9.52 equals 11.50
    HTH

  4. #4
    Join Date
    Nov 2008
    Posts
    18
    I have bit more doubt

    i want to diffentiate XPS from IDS, by running qurey

    i use {SELECT owner FROM systables WHERE TABNAME= ' VERSION'; } to retrive version and XPS shows

    owner
    8.50.FC1

    running onstat -V is not an option for me..
    pls help me on this.

  5. #5
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    IDS has versions 7, 9 (including marketing name 10 & 11)
    XPS has version 8.
    I do not understand what is confusing you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •