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