Introduction › Producing CA IDMS Reports › DATABASE Parameter

DATABASE Parameter

DATABASE is an optional parameter that you can use in a multiple dictionary environment or in a multiple system environment:

• In a multiple dictionary environment, you can retrieve report modules from one dictionary and run those modules against another dictionary; for example, obtain the report modules from the system dictionary and report on an application dictionary.
• In a multiple system environment, you can specify the remote nodes that control the dictionaries that contain either the report modules or the data of interest.

Syntax

 Col 2
     ▼         ┌─────────────────────────────────────┐
►►── DATABASE ─▼─┬─ DICTNAME=dictionary-name ──────┬─┴────────────────────────►◄
                 ├─ DBNAME=database-name ──────────┤
                 ├─ DICTNODE=dictionary-node-name ─┤
                 └─ DBNODE=database-node-name ─────┘

Parameters

DATABASE

Identifies the parameter. If used, the DATABASE parameter must be the first parameter submitted and must be coded starting in column 2. Only one DATABASE parameter can be specified per run. Any or all of the DATABASE options described below may be coded in any order.

DICTNAME

Specifies the name (up to 8 characters) of the dictionary in which the report modules are stored. The following considerations apply:

• The default dictionary is the system dictionary.
• If D-, C-, or AREPORT modules are stored in an application dictionary, the application dictionary must contain the source definitions for IDMSNWKA, the subschema required to run these reports.
• If the report is run under the central version, the specified dictionary must be known to the central version.
• If the report is run in local mode, the specified dictionary must be defined in the database name table load module associated with the DMCL used at runtime.

DBNAME

Specifies the name (up to 8 characters) of the dictionary that supplies the input data for D-, C-, and AREPORTs.

DICTNODE

Identifies the name of a system defined to the DC/UCF communications network that controls the dictionary that stores the report modules. Dictionary-node-name must be the name (up to 8 characters) of a node defined to the DC/UCF system.

DBNODE

Specifies the name of a DC/UCF system defined to the communications network that controls the dictionary that supplies the input data for D-, C-, and AREPORTs. Database-node-name must be the name (up to 8 characters) of a node defined to the DC/UCF system.