Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ECV_AH_Idnr int NUMBER(38,0) int int false Reference to OH
ECV_VName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Value name
ECV_Type smallint NUMBER(38,0) smallint smallint false Job Parameter
ECV_Encrypted smallint NUMBER(38,0) smallint smallint true Value Type (0=decrypted, 1=encrypted)
ECV_Connection smallint NUMBER(38,0) smallint smallint true 1 = Value represents the name of a Connection Object
ECV_Key varbinary(16) RAW(16) varchar(16) for bit data bytea true Key for encrypted Values
ECV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT text true Value
ECV_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if ECV_Value is stored in UTF-8 (1) or legacy encoding (0) if it is encrypted

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ECV ECV_AH_Idnr, ECV_VName, ECV_Type true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File