This statement adds databases to the distribution rule.
Function
The SESDCN control statement ADD-DISTRIBUTION-RULE-LIST describes which databases are added to the distribution rule and via which logical connections the different databases can be accessed.
You must use this statement to enter all databases that are to be involved in distributed processing and accessible from the configuration to which the SESDCN to be loaded belongs. This also applies to base tables processed by CALL DML application programs.
You can use the statement once or several times. Together with the entries created implicitly by SESAM/SQL (see the note on "Entering SESDCN control statements") the distribution rule may contain a maximum of 340 entries. You can, however, explicitly enter at least 300 databases and their associated networks.
You can use the ADD-DISTRIBUTION-RULE-ENTRY administration statement to enter additional databases in the distribution rule during the SESDCN session (see "ADD-DISTRIBUTION-RULE-ENTRY"). The administration statements MODIFY-DISTRIBUTION-RULE-ENTRY and REMOVE-DISTRIBUTION-RULE-ENTRY allow you to change entries in the distribution rule and remove them from it, respectively (see "MODIFY-DISTRIBUTION-RULE-ENTRY" and "REMOVE-DISTRIBUTION-RULE-ENTRY").
ADD-DISTRIBUTION-RULE-LIST | ||||||||||||||||||||||||
| ||||||||||||||||||||||||
Operands
CATALOG-NAME-1 =
First database entered in the distribution rule.
CATALOG-NAME-1 = *NONE
This is the default.
No more databases are entered.
CATALOG-NAME-1 = <filename 1..18 without-cat-gen-vers>(...)
Logical name of the database to be entered.
The logical database name is the name by which a database is addressed in the application program.
You also have to specify the logical database name for each base table to be processed by CALL DML application programs.
The logical database name must be unique throughout the network.
LINK-NAME = *HOME / <name 1..8>
Logical link name that provides the logical link to the associated entry in the ADD-NETWORK-LINK-LIST statement (see "ADD-NETWORK-LINK-LIST").
If the database to be entered is assigned to the same configuration to which SESDCN is to belong, select the default: *HOME. In this case the link to a remote DCN is unnecessary. A corresponding entry in the ADD-NETWORK-LINK-LIST statement is not required.
DBH-NAME = *BLANK / <alphanum-name 1..1>
Name of the DBH responsible for working with the database.
The default is a blank.
.
CATALOG-NAME -n =
n = 2-200
nth database entered in the distribution rule.
Up to 200 database entries are permitted.
The parameters of this operand are identical to those of the CATALOG-NAME-1 operand described above.