Adding new entries to the distribution table (&ADD DISTRIBUTION)

For UDS-D

 &ADD DISTRIBUTION,
    {NODE=processor-name,
          CONF=confname[,DB=dbname] |
     DB=dbname,SS=subschema-name |
     FILE=file-name }

processor-name
	Name of a host; must be no more than eight characters in length.
confname
	The first eight characters of configuration-name; must be unique in its first seven characters. The eighth character must not be ’@’. Trailing zeros are nonsignificant characters, i.e. there is no difference between confname ABC and confname ABC0.
dbname	Name of a database; may be up to 17 characters in length; must be unique network-wide.
subschema-name
	Name of a subschema; must be no more than 30 characters in length; must be unique network-wide in its first six characters. Only user subschemas may be specified. The PRIVACY-AND-IQF subschema and COMPILER subschema are not permitted in the distribution table.
:catid:	BS2000 catalog identifier In this case specifying :catid: is permitted (see section “Using pubsets in UDS/SQL”).
userid	User identification to which file-name is assigned
file-name
	Name of the file containing the entries to be added to the existing distribution table. Configuration-based passwords, if any, are read in from this file.

This command adds new entries to the distribution table (see section “Structure of the distribution table”).

NODE=...,CONF=...

These operands are used to specify a NODE/CONF entry.

The command is rejected if this configuration is already assigned to another host. In that case, the DAL command &CHANGE DISTRIBUTION should be used.

NODE=...,CONF=...,DB=...

These operands are used to specify a DB entry.

The DB entry is chained to the associated NODE/CONF entry if the latter already exists or the NODE/CONF entry is newly created if the specified entry does not yet exist. The two newly created entries are chained together.

DB=...,SS=...

These operands are used to specify an SS entry.

The SS entry is chained to the associated DB entry if the latter already exists or a new DB entry is created if the specified entry does not yet exist. The two new entries are chained together.

FILE=...

This operand is used to add the entries in this input file to the distribution table.

&ADD DISTRIBUTION only changes the local distribution table.

You cannot assign configuration-based passwords with this DAL command. For information on assigning them, see section “Configuration-based password protection” and the description of the DAL command &PWD DISTRIBUTION on "Assigning and changing a password (&PWD DISTRIBUTION)".

Changes to the distribution table do not take effect until the next READY statement is issued.

Example

DAL command	Content of distribution table
&ADD DIS,NODE=PROC3,CONF=CONFD	PROC3/CONFD
&ADD DIS,NODE=PROC3,CONF=CONFD,DB=DBD1	^ | DBD1-------+
&ADD DIS,NODE=PROC4,CONF=CONFE,DB=DBE1	DBE1D-->PROC4/CONFE
&ADD DIS,DB=DBE1,SS=SSE11	^ | SSE11---+
&ADD DIS,DB=DBF1,SS=SSF11	SSF11-->DBF1