getJrnInfo() Method

Usage

public java.lang.String getJrnInfo(java.lang.String pPropertyName)

Description

Returns generic information about a datastore's journalizing for a JKM while journalizing a model/datastore, or for a LKM/IKM in an interface.

Parameters

Parameter

Type

Description

pPropertyName

String

String containing the name of the requested property.

pPropertyName values

The following table lists the different values possible for pPropertyName :

Parameter value

Description

FULL_TABLE_NAME

Full name of the journalized datastore.

JRN_FULL_NAME

Full name of the journal datastore.

JRN_FULL_VIEW

Full name of the view linked to the journalized datastore.

JRN_FULL_DATA_VIEW

Full name of the data view linked to the journalized datastore.

JRN_FULL_TRIGGER

Full name of the trigger linked to the journalized datastore.

JRN_FULL_ITRIGGER

Full name of the Insert trigger linked to the journalized datastore.

JRN_FULL_UTRIGGER

Full name of the Update trigger linked to the journalized datastore.

JRN_FULL_DTRIGGER

Full name of the Delete trigger linked to the journalized datastore.

JRN_SUBSCRIBER

Name of the subscriber table in the work schema .

JRN_NAME

Name of the journalized datastore.

JRN_VIEW

Name of the view linked to the journalized datastore.

JRN_DATA_VIEW

Name of the data view linked to the journalized datastore.

JRN_TRIGGER

Name of the trigger linked to the journalized datastore.

JRN_ITRIGGER

Name of the Insert trigger linked to the journalized datastore.

JRN_UTRIGGER

Name of the Update trigger linked to the journalized datastore.

JRN_DTRIGGER

Name of the Delete trigger linked to the journalized datastore.

JRN_SUBSCRIBER

Name of the subscriber.

JRN_COD_MODE

Code of the journalized data model.

JRN_METHOD

Journalizing Mode (consistent or simple).

CDC_SET_TABLE

Full name of the table containing list of CDC sets.

CDC_TABLE_TABLE

Full name of the table containing the list of tables journalized through CDC sets.

CDC_SUBS_TABLE

Full name of the table containing the list of subscribers to CDC sets.

CDC_OBJECTS_TABLE

Full name of the table containing the journalizing parameters and objects.

Examples

The table being journalized is <%=odiRef.getJrnInfo("FULL_TABLE_NAME")%>