Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ORET_OH_Idnr int NUMBER(38,0) int int false ID of the job.
ORET_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for the job steps.
ORET_StepName varchar (40) VARCHAR2 (40 CHAR) varchar(40) varchar (40) false Name of the job step.
ORET_RetRange varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Range of return codes. Format: 0,1,3-5
ORET_Result smallint NUMBER(38,0) smallint smallint false Indicates whether a job fails if the return code is within the range of defined return codes. 0 = abend on defined return code, 1 succeed on defined return code

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ORET ORET_OH_Idnr, ORET_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_ORET_OH ORET_OH_Idnr OH_Idnr

Return to the Index File