Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

get version of database using select

3 posts in General Discussion Last posting was on 2006-05-24 12:06:13.0Z
Alex Posted on 2006-05-23 01:39:24.0Z
From: "Alex" <nowhere@invalid>
Newsgroups: ianywhere.public.general
Subject: get version of database using select
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Original-NNTP-Posting-Host: 210.48.84.77
Message-ID: <4472676f@forums-2-dub>
X-Original-Trace: 22 May 2006 18:37:51 -0700, 210.48.84.77
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 May 2006 18:37:54 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 May 2006 18:39:24 -0700
X-Trace: forums-1-dub 1148348364 10.22.108.75 (22 May 2006 18:39:24 -0700)
X-Original-Trace: 22 May 2006 18:39:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5367
Article PK: 1421

some of our clients have upgraded to 9.01, 9.02 while some are still hanging
around on 5.5
i want to know what version of the sql anywhere database they are running

can i do something like SELECT VERSION;
to get the major/minor version number

maybe the info is hidden in a sys table somewhere
can anyone help

thanks in advance

alex


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-05-23 12:44:39.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: get version of database using select
References: <4472676f@forums-2-dub>
In-Reply-To: <4472676f@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <44730358$1@forums-2-dub>
X-Original-Trace: 23 May 2006 05:43:04 -0700, keating-dm20.sybase.com
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 May 2006 05:43:05 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 May 2006 05:44:39 -0700
X-Trace: forums-1-dub 1148388279 10.22.108.75 (23 May 2006 05:44:39 -0700)
X-Original-Trace: 23 May 2006 05:44:39 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5369
Article PK: 1418

SELECT @@version
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Breck Carter [Team iAnywhere] Posted on 2006-05-24 12:06:13.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: get version of database using select
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <mmi872tmca11f58bmpl7p1jbg8pn4d6r1h@4ax.com>
References: <4472676f@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 24 May 2006 05:04:34 -0700, bcarter.sentex.ca
Lines: 35
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 May 2006 05:04:35 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 May 2006 05:06:13 -0700
X-Trace: forums-1-dub 1148472373 10.22.108.75 (24 May 2006 05:06:13 -0700)
X-Original-Trace: 24 May 2006 05:06:13 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5374
Article PK: 1424

SELECT @@VERSION will tell you the version of the SQL Anywhere
*software* that is being used. That may be all you need... however:

It is possible to use an older database with newer software, and
discovering the "database version" is not particularly easy (some
would argue it is actually impossible to do the job perfectly, and I
agree with them). Foxhound makes a determined effort, and in practice
it seems to do OK: http://www.risingroad.com/foxhound_beta_3.html

Breck

On 22 May 2006 18:39:24 -0700, "Alex" <nowhere@invalid> wrote:

>some of our clients have upgraded to 9.01, 9.02 while some are still hanging
>around on 5.5
>i want to know what version of the sql anywhere database they are running
>
>can i do something like SELECT VERSION;
>to get the major/minor version number
>
>maybe the info is hidden in a sys table somewhere
>can anyone help
>
>thanks in advance
>
>alex
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com