Name Type MSSql Type Oracle Type DB2 Nullable Description
JPOP_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JPOP_JPP_Lnr smallint NUMBER(38,0) smallint false ascending number of the element
JPOP_Location smallint NUMBER(38,0) smallint false 1=Pre, 2=Post
JPOP_JPOV_Lnr smallint NUMBER(38,0) smallint false ascending number of parameters in a condition/action
JPOP_JPOV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Variable name (S=Parameterset)
JPOP_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Variable name of referenced Prompt
JPOP_Value varchar(max) CLOB clob(128 M) INLINE LENGTH 1024 COMPACT true Variable value
JPOP_AltView smallint NUMBER(38,0) smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPOP JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName, JPOP_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPOP_JPOV JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName JPOV_OH_Idnr, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr, JPOV_VName

Return to the Index File