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.

path to sybase database

3 posts in General Discussion Last posting was on 2009-03-02 16:32:41.0Z
Sebastian Fedrau [SpecTec GmbH] Posted on 2009-03-02 13:36:40.0Z
From: "Sebastian Fedrau [SpecTec GmbH]" <sebastian.fedrau@spectec.net>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: path to sybase database
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49abe0e8@forums-1-dub>
Date: 2 Mar 2009 05:36:40 -0800
X-Trace: forums-1-dub 1236001000 10.22.241.152 (2 Mar 2009 05:36:40 -0800)
X-Original-Trace: 2 Mar 2009 05:36:40 -0800, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7390
Article PK: 5807

Hi all,

is there a way (e.g. a server variable) to get the path to the database
file? I'm writing a backup script and want to build the path to the
backup directory dynamically.


With kind regards,

Sebastian Fedrau


Graeme Perrow [Sybase iAnywhere] Posted on 2009-03-02 13:50:01.0Z
From: "Graeme Perrow [Sybase iAnywhere]" <ReplyToNewsgroupOnly-gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: ReplyToNewsgroupOnly-gperrowNO@SPAMianywhere.PLEASEcom
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: path to sybase database
References: <49abe0e8@forums-1-dub>
In-Reply-To: <49abe0e8@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49abe409$1@forums-1-dub>
Date: 2 Mar 2009 05:50:01 -0800
X-Trace: forums-1-dub 1236001801 10.22.241.152 (2 Mar 2009 05:50:01 -0800)
X-Original-Trace: 2 Mar 2009 05:50:01 -0800, vip152.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7391
Article PK: 5804

select db_property('file')

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs

Sebastian Fedrau [SpecTec GmbH] wrote:
> Hi all,
>
> is there a way (e.g. a server variable) to get the path to the database
> file? I'm writing a backup script and want to build the path to the
> backup directory dynamically.
>
>
> With kind regards,
>
> Sebastian Fedrau


Reg Domaratzki [Sybase iAnywhere] Posted on 2009-03-02 16:32:41.0Z
Newsgroups: ianywhere.public.general
Subject: Re: path to sybase database
From: "Reg Domaratzki [Sybase iAnywhere]" <FirstName.LastName@ianywhere.com>
References: <49abe0e8@forums-1-dub> <49abe409$1@forums-1-dub>
Organization: Sybase iAnywhere
Message-ID: <Xns9BC27570773B4RegDSybiAnywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 2 Mar 2009 08:32:41 -0800
X-Trace: forums-1-dub 1236011561 10.22.241.152 (2 Mar 2009 08:32:41 -0800)
X-Original-Trace: 2 Mar 2009 08:32:41 -0800, vip152.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7392
Article PK: 5809

"Graeme Perrow [Sybase iAnywhere]" <ReplyToNewsgroupOnly-

gperrowNO@SPAMianywhere.PLEASEcom> wrote in news:49abe409$1@forums-1-dub:

> select db_property('file')
>
> Graeme Perrow
> Senior Software Developer
> gperrow _at_ ianywhere _dot_ com
> Sybase iAnywhere Engineering
>
> SQL Anywhere Developer Community
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> SQL Anywhere Blog Center
> http://www.sybase.com/sqlanyblogs
>
>
> Sebastian Fedrau [SpecTec GmbH] wrote:
>> Hi all,
>>
>> is there a way (e.g. a server variable) to get the path to the
database
>> file? I'm writing a backup script and want to build the path to the
>> backup directory dynamically.
>>
>>
>> With kind regards,
>>
>> Sebastian Fedrau
>

Just remember that the path returned is relative to the machine where
the database engine is running, not the machine where the select was
executed from.

--
Reg Domaratzki, Sybase iAnywhere Solutions
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"