8. SQL Statements : CREATE LOCATION : Syntax
 
Syntax
The CREATE LOCATION statement has the following format:
[EXEC SQL] CREATE LOCATION location_name
WITH AREA = area_name,
USAGE = (usage_type {, usage_type}) | NOUSAGE
RAWPCT = n
location_name
Specifies the name to be assigned to the disk and directory combination. Must be a valid object name.
area_name
Specifies the disk and directory location to which the location is mapped. Must be a valid operating-system specification. This parameter can be specified using a quoted string or an unquoted string that does not include special (non-alphanumeric) characters.
Limits: Path name must not exceed 126 characters.
usage_type
Specifies the types of file that can be stored at this location. Valid values are:
DATABASE
WORK
JOURNAL
CHECKPOINT
DUMP
ALL
NOUSAGE
To prevent any files from being stored at the location, specify WITH NOUSAGE.
RAWPCT=n
Defines the relative amount of the area to be allocated to the location. RAWPCT=0 is equivalent to omitting the parameter, resulting in a cooked definition. When RAWPCT is greater than zero, the only valid usage is DATABASE.
Limits: 1 to 100