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.

version of a database file

2 posts in General Discussion (old) Last posting was on 2009-01-28 14:45:50.0Z
B Roman Posted on 2009-01-27 20:25:58.0Z
From: "B Roman" <brenda.s.roman@accenture.com>
Newsgroups: sybase.public.sqlanywhere
Subject: version of a database file
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <497f6dd6$1@forums-1-dub>
Date: 27 Jan 2009 12:25:58 -0800
X-Trace: forums-1-dub 1233087958 10.22.241.152 (27 Jan 2009 12:25:58 -0800)
X-Original-Trace: 27 Jan 2009 12:25:58 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:243
Article PK: 866686

Can anyone tell me how to get the version of the database that I am
connected to? I tried select @@version and it just gives me the version of
the SQL Anywhere software that I am running.

I also tried to select * from dbinfo, and the file version column only
returned 41.

Thank you.


Stephen Rice [Sybase] Posted on 2009-01-28 14:45:50.0Z
From: "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom>
Newsgroups: sybase.public.sqlanywhere
References: <497f6dd6$1@forums-1-dub>
Subject: Re: version of a database file
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49806f9e$1@forums-1-dub>
Date: 28 Jan 2009 06:45:50 -0800
X-Trace: forums-1-dub 1233153950 10.22.241.152 (28 Jan 2009 06:45:50 -0800)
X-Original-Trace: 28 Jan 2009 06:45:50 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:244
Article PK: 866687

Prior to v9 there was no way to tell exactly what version the database was
created under.

In v9.0.1 there is a SYSHISTORY table that tracks the creation/upgrade
information.

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"B Roman" <brenda.s.roman@accenture.com> wrote in message
news:497f6dd6$1@forums-1-dub...
> Can anyone tell me how to get the version of the database that I am
> connected to? I tried select @@version and it just gives me the version
> of the SQL Anywhere software that I am running.
>
> I also tried to select * from dbinfo, and the file version column only
> returned 41.
>
> Thank you.
>