ALTER WRITEFILE statement
400
ALTER WRITEFILE statement
Use this statement to change the name of the read-only database file to which
a write file refers.
ALTER WRITEFILE
write-file-name
… REFERENCES
db-file-name
write-file-name
|
db-file-name:
string
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.
Not supported on Windows CE.
Automatic commit.
"CREATE WRITEFILE statement" on page 484
"The Write File utility" on page 151
"Working with write files" on page 792 of the book ASA User’s Guide
"Using the utility database" on page 794 of the book ASA User’s Guide
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" on page 224.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ 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’
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example
To Next Page
Loading...