ASA SQL Reference
  SQL Statements

CREATE WRITEFILE statement

Description 

Use this statement to create a write file for a database.

Syntax 

CREATE WRITEFILE write-file-name
FOR DATABASE db-file-name [ KEY key ]
[ LOG OFF | LOG ON [ log-file-name [ MIRROR mirror-file-name ] ] ]

write-file-name | db-file-name | log-file-name | mirror-file-name : string

Usage 

Creates a database write file with the supplied name and attributes.

The file names (write-file-name, db-file-name, log-file-name, mirror-file-name) are strings containing operating system file names.

For information on strings, see Strings.

If you specify no path, or a relative path, the file is created relative to the current working directory of the server.

You cannot create a write file for a database that is currently loaded.

Permissions 

The permissions required to execute this statement are set on the server command line, using the -gu option. The default setting is to require DBA authority.

The account under which the server is running must have write permissions on the directories where files are created.

Not supported on Windows CE.

You must specify a KEY value if you want to create a writefile for a strongly encrypted database.

Side effects 

An operating system file is created.

See also 

CREATE DATABASE statement

The Write File utility

Working with write files

Encryption Key connection parameter [DBKEY]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement creates a write file.

CREATE WRITEFILE 'c:\\sybase\\my_db.wrt'
FOR DATABASE 'c:\\sybase\\my_db.db'
LOG ON 'e:\\logdrive\\my_db.log'