Name Type MSSql Type Oracle Type DB2 Nullable Description
OY_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OY_Lnr smallint NUMBER(38,0) smallint false ascending number
OY_SyncName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true used sync object
OY_StartAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) true start action to check the sync object
OY_EndAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) true action to be taken if the task ends normally
OY_AbendAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) true action to be taken if the task ends abnormally
OY_Else char (1) CHAR (1 CHAR) char(1) true wait/abend if the sync object cannot be reserved

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