| 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. |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_OCV | OCV_OH_Idnr, OCV_VName, OCV_Type | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_OCV_OH | OCV_OH_Idnr | OH_Idnr |
Return to the Index File