Reference Manual
   CHAPTER 9. SQL Statements     

CREATE WRITEFILE statement

Function 

To create a write file for a database.

Syntax 

CREATE WRITEFILE write-file-name
... FOR DATABASE db-file-name
... [ LOG OFF | LOG ON [ log-file-name [ MIRROR mirrorfile-name ] ] ]

Parameters 

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

Permissions 

The permissions required to execute this statement are set on the server command line, using the -gu command-line 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.

Side effects 

An operating system file is created.

See also 

CREATE DATABASE statement

The Write File utility

Working with write files

Description 

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. As literal strings, they must be enclosed in single quotes. If you specify a path, any backslash characters (\) must be doubled according to the rules for strings in SQL.

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.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Adaptive Server Enterprise provides a CREATE DATABASE statement, but with different options.

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'