|
|
|
Valid in: SQL, ESQL
The Drop Location statement deletes a name that was assigned to a physical disk location using the create location statement. Note that you can only drop a data or work location if no currently existing database has been extended to it. You cannot drop other types of locations.
|
|
|
The Drop Location statement has the following format:
[EXEC SQL] DROP LOCATION location_name;
|
|
|
You cannot use host language variables in an embedded Drop Location statement.
|
|
|
You must have the maintain_locations privilege and be working in a session that is connected to the iidbdb.
|
|
|
The Drop Location statement locks pages in the iilocation_info catalog.
|
|
|