ASA SQL Reference
  SQL Statements

ALTER WRITEFILE statement

Description 

Use this statement to change the name of the read-only database file to which a write file refers.

Syntax 

ALTER WRITEFILE write-file-name
REFERENCES db-file-name [ KEY key ]

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

Usage 

The ALTER WRITEFILE statement changes the name of the read-only database file to which the write file refers. If you move the database file from one directory to another, you can use this statement to point the write file to the new location.

The path name of the database file is relative to the database server's current directory at startup.

For information on escaping backslash characters in strings, see Strings.

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.

You need to specify a KEY value if you want to change the writefile for a strongly encrypted database.

Not supported on Windows CE.

Side effects 

Automatic commit.

See also 

CREATE WRITEFILE statement

The Write File utility

Working with write files

Using the utility database

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 changes the existing write file c:\readwrite.wrt to point to the database file h:\readonly.db.

ALTER WRITEFILE 'c:\\readwrite.wrt'
REFERENCES 'h:\\readonly.db'