CL Command Reference - ADDDPRSUBM

CL Command List > ADDDPRSUBM Reference

Description:

The Add DPR Subscription Member(ADDDPRSUBM) command adds a member to an existing subscription set, The source table has been registered with the Add DPR Registration (ADDDPRREG) command. The ADDDPRSUBM command reads the column definitions of the registered source table and uses them to create the target table automatically if the CRTTGTTBL parameter is specified as *YES. If the CRTTGTTBL parameter is specified as *NO, then an existing table will be used.

If the library specified on the TGTTBL parameter does not have a journal or journal receiver, they are created. The journal is called QSQJRN. The journal receiver is called QSQJRN nnnn , where nnnn is 0001 if no other journal receivers exist, and is incremented by 1 until an available name is found.

If the target table is created during the subscription, the target table is journaled to the QSQJRN journal. Otherwise, you must set up journaling for the target table separately.

If the value of the ADDREG parameter is *YES, the ADDDPRSUBM command also automatically registers the target table on the target server as a potential source table for another subscription. This is called auto-registration .

This command supports the iSeries environment only, and not the other databases that support DataPropagator.
. Note: Do not precede an entry with an asterisk unless that entry is shown on the display itself or in the help information with an asterisk.


Examples:

None.