GENERATE SUBSCHEMA Statement

Syntax
idms19
Syntax
►►─┬─── GENerate SUBschema name is subschema name ─────┬─────────────────────►    │             ┌───── , ───────┐                     │    └─── FOR dbd -▼- dbd-name. ───┴─────────────────────┘    ►─┬───────────────────────────────────────────────────────────┬─────────────►◄    ├─ SCHema ─────┬── name is ─┬─ schema-name ─────┬── . ──────┘    └─ DICTionary ─┘            └─ dictionary-name ─┘
Parameters
  • GENerate SUBschema name is
    subschema-name
    Specifies that you want the syntax generator to produce a subschema source definition.
    Subschema-name
    is the 1- to 8-character name of the output source definition. This is the name that you will supply as input to the CA IDMS/DB subschema compiler.
  • FOR DBD
    dbd-name
    Specifies the DBD control block(s) from which to derive the subschema source. You can specify multiple DBDs, separated by commas, to match the DBDs referenced in the associated PSB. Each
    dbd-name
    must be a 1- to 8-character name.
    Be sure to specify all the DBDs associated with the PSB you will be using; this includes all physical, index, and logical DBDs.
  • SCHema name is
    schema-name
    Optionally supplies the name of the associated schema. If you omit the
    schema-name
    , the syntax generator will supply a default schema name. You can only include one SCHEMA NAME statement.
  • DICTionary name is
    dictionary-name
    Optionally identifies the name of the dictionary to be used in the SIGNON statement in the generated subschema syntax.
    If you omit the DICTIONARY NAME statement, the syntax generator will omit the DICTIONARY NAME IS clause in the SIGNON statement. As a result, the generated subschema source will be placed in the default dictionary.
    You can only include one DICTIONARY NAME statement.
Example
GENERATE SUBSCHEMA NAME IS SUBSCHA FOR DBD PHYSDB1, PHYSDB2, INDXDBD. SCHEMA NAME IS SCHEMA1. DICTIONARY NAME IS PRODDIC.
Figure 30. Sample Subschema GENERATE and NAME statements