Physical Database DDL Statements › DBTABLE Statements › Entity Currency › Parameters

Parameters

dbtable-name

Specifies the name of a database name table. Database-name-table is a 1- to 8-character value that assigns a unique name to the database name table within the dictionary.

ADD SUBSCHEMA

Identifies the database to be accessed by adding or updating a DBTABLE mapping that maps the name of the subschema specified in a BIND RUN-UNIT statement to a corresponding subschema and its associated database name definition. ADD is the default.

New DBTABLE mappings are added at the end of all existing mappings associated with the database name table.

See "Usage" below for information on using this clause.

ssc-name-1

Specifies a 1- to 8-character name of a subschema passed on a BIND RUN-UNIT statement. You can use wildcards to specify the subschema name as described below under "Usage".

ssc-name-2

Specifies a 1- to 8-character name of a subschema to which CA IDMS/DB maps the subschema named on a BIND RUN-UNIT statement. You can use wildcards to specify the subschema name as described in the "Usage" topic in this section.

db-name

Identifies the database to be accessed. Db-name is a 1- to 8-character value that identifies a database name definition in the database name table. See the "Usage" topic in this section for information on how CA IDMS/DB uses this database name at runtime.

DROP SUBSCHEMA

Drops a DBTABLE mapping from the database name table. The name specified in ssc-name-1 must be the same as that in a subschema mapping associated with the database name table.

ALL

Removes all DBTABLE mappings from the database name table. This can be useful when the mappings must be reordered. You can drop all mappings and then re-add them in a different sequence.

dbtable-load-module-name

Specifies the name of the database name table load module to delete from the DDLCATLOD area.

PERMANENT

Physically erases the database name table load module. By default, IDMS/DB logically erases the database name table load module and physically erases it upon system startup.

DETails

Displays or punches details about the database name table.

HIStory

Displays or punches:

• The user who defined the database name table
• The user who last updated the database name table
• The date the database name table was created
• The date the database name table was last updated

ALL

Displays or punches all information about the database name table. ALL is the default action for a DISPLAY or PUNCH verb.

NONe

Displays or punches the name of the database name table.