CA IDMS DLI Transparency Syntax Generator › GENERATE SUBSCHEMA Statement

GENERATE SUBSCHEMA Statement

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