Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access


Directory access servers

A directory access server is a remote server that gives you access to the local file structure of the computer running the database server. Once you are connected to the directory access server, you use proxy tables to access any subdirectories on the computer. Database users must have an external login to use the directory access server.

You cannot alter a directory access server after it is created. If you need to change a directory access server, you must drop it and recreate it with different settings. You must first drop any proxy tables that reference the directory access server and then recreate them after recreating the directory access server.

The following describes the format of the proxy table.

  • permissions VARCHAR(10)   A Posix-style permission string such as "drwxrwxrwx".

  • size BIGINT   The size of the file in bytes.

  • access_date_time TIMESTAMP   The date and time the file was last accessed (for example, 2010-02-08 11:00:24.000).

  • modified_date_time TIMESTAMP   The date and time the file was last modified (for example, 2009-07-28 10:50:11.000 ).

  • create_date_time TIMESTAMP   The date and time the file was created (for example, 2008-12-18 10:32:26.000).

  • owner VARCHAR(20)   The user ID of the file's creator (for example, "root" on Linux). For Windows, this value is always "0".

  • file_name VARCHAR(260)   The name of the file, including a relative path (for example, bin\perl.exe).

  • contents LONG BINARY   The contents of the file when this column is explicitly referenced in the result set.

Queries on directory access proxy tables
Creating directory access servers (Sybase Central)
Creating directory access servers (SQL)
Dropping directory access servers (Sybase Central)
Dropping directory access servers (SQL)