 |
» |
|
|
|
Generates SQL commands necessary to recreate authorities for
section or table space.
Scope | |
SQLGEN Only SQLGEN Syntax | |
>> [GENERATE] SPACEAUTH
Schema File Name or '//' to STOP command >> SchemaFileName
DBEFileSetName >> DBEFileSetName
Parameters | |
- SchemaFileName
is the name of the schema file where SQLGEN places the generated commands.
- DBEFileSetName
is the name of the DBEFileSet for which section or
table space authorities have been granted.
Example | |
>> SPACEAUTH
ALLBASE/SQL Command Generator for SPACEAUTH
Schema File Name or '//' to STOP command >> SPAUTH
Please enter DBEFileSet Names. Type @ for all, ? for a list of
DBEFileSet Names, or RETURN to quit.
DBEFileSet Name >> PURCHFS
Generating command to GRANT SPACE AUTHORITY ON DBEFileSet PURCHFS
DBEFileSet Name >> Return
|
Schema File Produced | |
GRANT TABLESPACE ON DBEFILESET PURCHFS
TO PUBLIC;
GRANT SECTIONSPACE ON DBEFILESET PURCHFS
TO PUBLIC;
COMMIT WORK;
|
|
