Hello,

is it possible to get the filename including path from a
running database on a SQL Anywhere 9.0.2? I need the path
from the view of the server.

Kind regards
Andreas

Andreas,

use "select db_property('File')".
Note that the file path is always from the server's point of view.
The log's path is available via "select db_property('LogName')"

HTH
Volker

AH wrote:

Hello Volker,

it works, thank you.

Andreas

To have the picture complete it would be nice to also have the name of
the server.

Is this possible?

Thanks
Eric

Volker Barth schreef:

Then use
select property('Name'), property('MachineName')
-> this will give you both the database server name (as used in
connection strings in the ENG param) and the name of the box the db
server is running on.

There are a lot of other senseful server-, database- and
connection-level properties.

HTH
Volker


Ontsnapt wrote: