GENERATE SCHEMA Statement

Syntax
idms
Syntax
 ►►─┬── GENerate ──┬────────┬───────── SCHema name is schema-name ──┬─────────►     │              └─ LOAD ─┘                                       │     │            ┌──── , ──────┐                                    │     └── FOR dbd -▼- dbd-name. ─┴────────────────────────────────────┘  ►── DICTionary name is dictionary-name. ────────────────────────────────────►◄  
Parameters
  • GENerate SCHema name is
    schema-name
    Specifies that you want the syntax generator to produce a schema source definition.
    Schema-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 schema compiler.
  • LOAD
    Produces a schema definition suitable for use with the CA IDMS DLI Transparency load utility. Specifically, it creates a schema in which the sets are defined as OPTIONAL MANUAL. Alternatively, you can use an already generated schema definition and change its sets to OPTIONAL MANUAL. If you do this, be sure to change the set definitions back to their original state after the load.
  • FOR DBD
    dbd-name
    Specifies the DBD control block(s) from which to derive the schema 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.
  • DICTionary name is
    dictionary-name
    Optionally identifies a dictionary name to be used in the SIGNON statement in the generated schema 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 schema source will be placed in the default dictionary.
Example
GENERATE SCHEMA NAME IS SCHEMA1 FOR DBD PHYSDB1, PHYSDB2, INDXDBD. DICTIONARY NAME IS PRODDIC.
Figure 28. Sample Schema GENERATE and NAME statements