Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EJPCV_AH_Idnr int NUMBER(38,0) int int false Reference to AH
EJPCV_EJPP_Lnr smallint NUMBER(38,0) smallint smallint false Reference to the jobplan process (EJPP)
EJPCV_VName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Value name
EJPCV_Type smallint NUMBER(38,0) smallint smallint false Job Parameter
EJPCV_Encrypted smallint NUMBER(38,0) smallint smallint true Value Type (0=decrypted, 1=encrypted)
EJPCV_Connection smallint NUMBER(38,0) smallint smallint true 1 = Value represents the name of a Connection Object
EJPCV_Key varbinary(16) RAW(16) varchar(16) for bit data bytea true Key for encrypted Values
EJPCV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT text true Value
EJPCV_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if EJPCV_Value is stored in UTF-8 (1) or legacy encoding (0) if it is encrypted

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPCV EJPCV_AH_Idnr, EJPCV_EJPP_Lnr, EJPCV_VName, EJPCV_Type true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File