determine server version via SQL

Posted in 2007

Summary

Jesse asked how to get the IDS server version from SQL, like @@VERSION in SQL Server. Mark Scranton gave SELECT DBINFO('version', 'full'), and the 'major' and 'minor' variants, FROM systables WHERE tabid = 1. Jack Parker suggested a version entry in systables. Jesse confirmed the DBINFO answer was perfect. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: SQL Development & Query Writing

Jesse — Thu, 27 Sep 2007 10:23:05 -0700 — source: Usenet: comp.databases.informix

Hi, how can I determine the IDS server version from a SQL query? I'm looking for something similar to @@VERSION in SQL Server for example. Thanks, Jesse

↪ replying to Jesse

mark.scranton@gmail.com — Thu, 27 Sep 2007 22:19:31 -0000 — source: Usenet: comp.databases.informix

On Sep 27, 1:23 pm, Jesse <goo...@jessehersch.fastmail.fm> wrote: > Hi, > > how can I determine the IDS server version from a SQL query? I'm > looking for something similar to @@VERSION in SQL Server for example. > > Thanks, > Jesse database sysmaster; SELECT DBINFO('version', 'full') FROM systables WHERE tabid = 1; SELECT DBINFO('version', 'major') FROM systables WHERE tabid = 1; SELECT DBINFO('version', 'minor') FROM systables WHERE tabid = 1; HTH - Mark Scranton

↪ replying to Jesse

Jack Parker — Thu, 27 Sep 2007 21:06:13 -0400 — source: Usenet: comp.databases.informix

Look for an entry in systables with a tabname of ' VERSION' or something like that. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Jesse Sent: Thursday, September 27, 2007 1:23 PM To: informix-list@iiug.org Subject: determine server version via SQL Hi, how can I determine the IDS server version from a SQL query? I'm looking for something similar to @@VERSION in SQL Server for example. Thanks, Jesse _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to mark.scranton@gmail.com

Jesse — Thu, 27 Sep 2007 19:50:42 -0700 — source: Usenet: comp.databases.informix

Thanks, this is perfect. On Sep 27, 3:19 pm, "mark.scran...@gmail.com" <mark.scran...@gmail.com> wrote: > On Sep 27, 1:23 pm, Jesse <goo...@jessehersch.fastmail.fm> wrote: > > > Hi, > > > how can I determine the IDS server version from a SQL query? I'm > > looking for something similar to @@VERSION in SQL Server for example. > > > Thanks, > > Jesse > > database sysmaster;> > SELECT DBINFO('version', 'full') > FROM systables > WHERE tabid = 1; > > SELECT DBINFO('version', 'major') > FROM systables > WHERE tabid = 1; > > SELECT DBINFO('version', 'minor') > FROM systables > WHERE tabid = 1; > > HTH - > Mark Scranton

Glossary

IDS (Informix Dynamic Server)