Up to 30 subschemas can be explicitly specified in one BPSQLSIA run. With PRINT *ALL, however, BPSQLSIA generates relational schema information for all subschemas of the database, regardless of how many exist.
BPSQLSIA outputs the relational schema information in the order in which the subschemas appear in the COSSD, even if a different order is specified in the PRINT command.
The PRINT statement may be specified more than once.
PRINT-RELATIONAL-SCHEMAINFO | ||||||||||||
| ||||||||||||
SUBSCHEMA-NAME = *ALL
Relational schema information is generated for all subschemas of the database. All further PRINT statements are ignored.
SUBSCHEMA-NAME = *ALL-EXCEPT(...)
Relational schema information is generated for all subschemas of the database except for those listed following *ALL-EXCEPT.
NAME = list-poss(20): <subschema-name>
Names the subschemas for which no relational schema information is to be generated.
SUBSCHEMA-NAME = list-poss(20): <subschema-name>
Relational schema information is generated for all the named subschemas.