CA IDMS DLI Transparency Syntax Generator › GENERATE SCHEMA Statement

GENERATE SCHEMA Statement

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