Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OY_OH_Idnr int NUMBER(38,0) int int false ID of the object.
OY_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for the sync objects used within this object.
OY_SyncName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the sync object.
OY_StartAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Start action to check the sync object.
OY_EndAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Action to be taken if the task ends normally.
OY_AbendAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Action to be taken if the task ends abnormally.
OY_Else char (1) CHAR (1 CHAR) char(1) char (1) true Defindes the action if the sync object cannot be reserved. Wait or abend.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OY_SyncName OY_SyncName false false false false
PK_OY OY_OH_Idnr, OY_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OY_OH OY_OH_Idnr OH_Idnr

Return to the Index File