The SPECIFY-SCHEMA statement defines the schema that contains the objects for which the database is to be processed.
This statement is only offered if the database is assigned with LINK=DATABASE;
otherwise, the schema name is specified in the OPEN-DATABASE statement.
If the SPECIFY-SCHEMA statement is not entered as the first statement after ALLOCATE-BUFFERPOOL, the user schema is assumed.
After the initial schema specification, the SPECIFY-SCHEMA statement is no longer offered in the SDF mask.
SPECIFY-SCHEMA |
SCHEMA-NAME = *STD / <schema-name> |
SCHEMA-NAME = *STD
The name of the user schema that was defined for the database is used (default value).
SCHEMA-NAME = <schema-name>
schema-name specifies the database schema for whose objects the BREORG statements are to be executed.
Possible values:
PRIVACY-AND-IQF-SCHEMA
COMPILER-SCHEMA
Name of the user schema
In order to process a database, BREORG requires information on the size of the realms, the record types, and the set relations in the database. The schema name allows BREORG to access the SIA in which this information is contained and subsequently modified as required.