Reference Manual
   CHAPTER 9. SQL Statements     

ALTER WRITEFILE statement

Function 

To modify the configuration of a write file.

Syntax 

ALTER WRITEFILE write-file-name
... REFERENCES db-file-name

Permissions 

Must have DBA authority.

Not supported on Windows CE.

Side effects 

Automatic commit.

See also 

CREATE WRITEFILE statement

The Write File utility

Working with write files

Description 

The ALTER WRITEFILE statement changes the read-only database file to which the 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.

Standards and compatibility 

• SQL/92     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'