RR.PARAM Configuration

The RR.PARAM application is used to configure the tables required for the Relational Replication database.

Fields

Field	Description
@ID or PARAM.ID	Accepts a valid VOC record, which should have an Oracle file name. The corresponding application should have: Valid FILE.CONTROL record. PGM.FILE record with HULTDW type. Template routine, if PGM.FILE type is not D. Valid STANDARD.SELECTION record, if PGM.FILE does not exist.
ILP.REQUIRED	Indicates whether or not initial load processing is required for the table. While enabling an application for Relational Replication, mark the ILP Required as YES in the checkbox. This will allow the ILP process for the respective application to use the RR.TAKEON service. If ILP.ENABLED is not set the first time then the user cannot set it later. Once the ILP for an application is performed using the RR.TAKEON Service the ILP.ENABLED option will be disabled.

Field

Description

@ID or PARAM.ID

Accepts a valid VOC record, which should have an Oracle file name.

The corresponding application should have:

Valid FILE.CONTROL record.
PGM.FILE record with HULTDW type.
Template routine, if PGM.FILE type is not D.
Valid STANDARD.SELECTION record, if PGM.FILE does not exist.

ILP.REQUIRED

Indicates whether or not initial load processing is required for the table.

While enabling an application for Relational Replication, mark the ILP Required as YES in the checkbox. This will allow the ILP process for the respective application to use the RR.TAKEON service.

If ILP.ENABLED is not set the first time then the user cannot set it later.

Once the ILP for an application is performed using the RR.TAKEON Service the ILP.ENABLED option will be disabled.

Overrides

Field	Description
RR-TABLE.CATPURE.IN.RR	The table is captured in the Relational Replication database. It is displayed the first time the table is configured.
RR-NO.ZERO.AUTH	Zero authorisation is used. It is recommended to use the Input and Authorize mode. This is displayed when a table is configured with zero authorisation.

The RR.XSD.EVENTS table

This table stores the XSD events generated during the RR.PARAM configuration.

Field	Description
@ID or XSD.EVENT.ID	The UNIQUEKEY ID.
TRANSACTION.TIME	The creation time of the event.
APPLICATION.ID	The application the event is generated for,
XSD	Either the XSD value or an ADDED/REMOVED/DELISTED message.
XX<COMPANY	The company value as Mnemonic-Company code.
XX-XX<FILE.SUFFIX	The file suffix of the table.
XX>XX>ORCL.FILE.NAME	The Oracle file name configured in the VOC.

Dark Mode

Expand/Collapse

In this topic