dbTalk Databases Forums  

Get ASA version number through sql

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Get ASA version number through sql in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Claude
 
Posts: n/a

Default Get ASA version number through sql - 09-07-2009 , 06:22 AM






I have an application that works with different databaese and different
versions of ASA.
When I start the application, I would like to know, if I am with ASA, which
version of server is it.

I send a dummy sql to the database and look in the sqlca.sqlreturndata, but
I receive Sybase SQL Anywhere ( for older version ) , and SQL Anywhere (
for syb 10 ) ( or Oracle.... if oracle )

How can I get the version/built number of sybase?

Claude

Reply With Quote
  #2  
Old   
Glenn Paulley [Sybase iAnywhere]
 
Posts: n/a

Default Re: Get ASA version number through sql - 09-07-2009 , 07:32 AM






Use

SELECT @@VERSION FROM DUMMY

You can find other global variables such as @@version in the help - find
the section

SQL Anywhere Server - SQL Reference » Using SQL » SQL language elements
» Variables » Global variables

Glenn

Claude wrote:
Quote:
I have an application that works with different databaese and different
versions of ASA.
When I start the application, I would like to know, if I am with ASA, which
version of server is it.

I send a dummy sql to the database and look in the sqlca.sqlreturndata, but
I receive Sybase SQL Anywhere ( for older version ) , and SQL Anywhere (
for syb 10 ) ( or Oracle.... if oracle )

How can I get the version/built number of sybase?

Claude


--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.