| 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 |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_AJPCV | AJPCV_AH_Idnr, AJPCV_AJPP_Lnr, AJPCV_VName, AJPCV_Type | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_AJPCV_AJPP | AJPCV_AH_Idnr, AJPCV_AJPP_Lnr | AJPP_AH_Idnr, AJPP_Lnr |
Return to the Index File