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
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
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
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