Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EY_AH_Idnr int NUMBER(38,0) int int false reference to the executive header (EH)
EY_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the element
EY_SyncName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true SYNC object being used
EY_StartAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true start action for checking the SYNC object
EY_EndAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true action to be taken when the task ends normally
EY_AbendAction varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true action to be taken when the task ends abnormally
EY_Else char (1) CHAR (1 CHAR) char(1) char (1) true wait/abend if SYNC could not be reserved
EY_Status int NUMBER(38,0) int int false value of this SYNC clause
EY_FiFoNr bigint NUMBER(38,0) bigint bigint true FirstInFirstOut Ranking
EY_SType char (1) CHAR (1 CHAR) char(1) char (1) true space=local, G=global

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_EY_SyncName EY_SyncName, EY_Status, EY_AH_Idnr false false false false
NK_EY_SyncName2 EY_AH_Idnr, EY_Status, EY_SyncName false false false false
PK_EY EY_AH_Idnr, EY_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File