|
» |
|
|
|
Generates SQL commands to recreate one or more tempspaces in
a DBEnvironment. Scope | |
SQLGEN Only SQLGEN Syntax | |
>> [GENERATE] TEMPSPACE[S] Schema File Name or '//' to STOP command >> SchemaFileName
TEMPSPACE Name >> TempSpaceName
Parameters | |
- SchemaFileName
is the name of the schema file where SQLGEN places generated commands.
- TempSpaceName
is the name of the tempspace you wish to generate.
Description | |
GENERATE TEMPSPACES builds CREATE TEMPSPACE commands to
recreate one or more temporary spaces in the DBEnvironment.
Example | |
>> generate tempspace
ALLBASE/SQL Command Generator for Temp Space
Schema File Name or '//' to STOP command >> temps
Please enter TEMPSPACE Names. Type @ for all, ? for a list of
TEMPSPACE Names, or RETURN to quit.
TEMPSPACE Name >> @
Generating command to CREATE TEMPSPACE TEMPSPACE1
>>
|
Schema File Produced | |
/* This file was created with a user language environment of */
/* NATIVE-3000 */
CREATE TEMPSPACE TEMPSPACE1
WITH MAXFILEPAGES = 1000,
LOCATION = TEMP.SOMEACCT;
COMMIT WORK;
~
|
|