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 |
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 |
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