Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OCV_OH_Idnr int NUMBER(38,0) int int false ID of the object.
OCV_VName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of the value.
OCV_Type smallint NUMBER(38,0) smallint smallint false Parameter type of the task. SAP: 0 = jxpb job parameter, 1 = http connection, 2 = rfc connection, 5 = connection object; DB: 1 = db connection parameter; RA: 2 = job panel, 3 = general panel, 4 = connection panel, 5 = agent panel, 6 = others panel, 7 = pushed values, 8 = new request; JCP: 8 = Certificate with private and public key for SAML login; HOST: 0 = agent variables;
OCV_Encrypted smallint NUMBER(38,0) smallint smallint true Indicates whether the value is encrypted or not. 0 = not encrypted, 1 = encryption type 1 (deprecated), 2 = encryption type 2 (new)
OCV_Connection smallint NUMBER(38,0) smallint smallint true Indicates whether or not the value is a connection value.
OCV_Key varbinary(16) RAW(16) varchar(16) for bit data bytea true Key for encrypted values.
OCV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT text true The value.
OCV_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if OCV_Value is stored in UTF-8 (1) or legacy encoding (0) if it is encrypted

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OCV OCV_OH_Idnr, OCV_VName, OCV_Type true true true false

Foreign Keys:

Name Local References Foreign References
FK_OCV_OH OCV_OH_Idnr OH_Idnr

Return to the Index File