Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EJPOP_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH) (RunID
EJPOP_EJPP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan process (Task Lnr)
EJPOP_Location smallint NUMBER(38,0) smallint smallint false 1=Pre, 2=Post
EJPOP_EJPOV_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of parameters in a condition/action
EJPOP_EJPOV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name (S=Parameterset)
EJPOP_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of referenced Prompt
EJPOP_Value varchar(max) CLOB clob(128 M) INLINE LENGTH 1024 COMPACT text true Variable value
EJPOP_AltView smallint NUMBER(38,0) smallint smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPOP EJPOP_AH_Idnr, EJPOP_EJPP_Lnr, EJPOP_Location, EJPOP_EJPOV_Lnr, EJPOP_EJPOV_VName, EJPOP_VName true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File