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?

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?

9.50 equals 10.00
9.51 equals 11.10
9.52 equals 11.50
HTH

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.

IDS has versions 7, 9 (including marketing name 10 & 11)
XPS has version 8.
I do not understand what is confusing you.