Name Type MSSql Type Oracle Type DB2 Nullable Description
AJPOP_AH_Idnr int NUMBER(38,0) int false reference to the archive header (AH) (RunID)
AJPOP_AJPP_Lnr smallint NUMBER(38,0) smallint false ascending number of the jobplan process (Task Lnr)
AJPOP_Location smallint NUMBER(38,0) smallint false 1=Pre, 2=Post
AJPOP_AJPOV_Lnr smallint NUMBER(38,0) smallint false ascending number of parameters in a condition/action
AJPOP_AJPOV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Variable name (S=Parameterset)
AJPOP_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Variable name of referenced Prompt
AJPOP_Value varchar(max) CLOB clob(128 M) INLINE LENGTH 1024 COMPACT true Variable value
AJPOP_AltView smallint NUMBER(38,0) smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPOP AJPOP_AH_Idnr, AJPOP_AJPP_Lnr, AJPOP_Location, AJPOP_AJPOV_Lnr, AJPOP_AJPOV_VName, AJPOP_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPOP_AJPOV AJPOP_AH_Idnr, AJPOP_AJPP_Lnr, AJPOP_Location, AJPOP_AJPOV_Lnr, AJPOP_AJPOV_VName AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr, AJPOV_VName

Return to the Index File