SQL Language Guide : 8. SQL Statements : ALTER LOCATION
 
Share this page                  
ALTER LOCATION
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ALTER LOCATION statement changes the type of files that can be created at an existing location.
Note:  You must be connected to the iidbdb database to issue CREATE/ALTER/DROP LOCATION statements.
Current usage of the location is unaffected, but future attempts to extend a database to the target extension are constrained by the new usage setting.
This statement has the following format:
ALTER LOCATION location_name
   WITH USAGE = (usage_type {, usage_type}) | NOUSAGE
location name
Specifies the name of an existing disk and directory combination.
usage_type
Specifies the types of file that can be stored at this location. Valid values are:
DATABASE
WORK
CHECKPOINT
JOURNAL
DUMP
ALL
NOUSAGE
Prevents any files from being stored at the location.