Create a New Location
Use the SQL statement CREATE LOCATION to create a new location.
To create a location "myloc1" in the area "D:\myarea1" for database file usage
Type the following SQL statement when connected to the myloc1 database:
CREATE LOCATION myloc1 WITH AREA = 'D:\myarea1', USAGE = (DATABASE);
To alter the location "invoix" in "area2" to allow usage as a work area only
ALTER LOCATION invoix WITH USAGE = (WORK);
To drop the location "duplicate"
DROP LOCATION DUPLICATE;