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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPCV AJPCV_AH_Idnr, AJPCV_AJPP_Lnr, AJPCV_VName, AJPCV_Type true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPCV_AJPP AJPCV_AH_Idnr, AJPCV_AJPP_Lnr AJPP_AH_Idnr, AJPP_Lnr

Return to the Index File