Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OVD_OH_Idnr int NUMBER(38,0) int int false ID of the variable object.
OVD_Type varchar (2) VARCHAR2 (2 CHAR) varchar(2) varchar (2) true Defines the data type of the variable object. C = text, D = date, N = number, TI = time, TS = timestamp
OVD_VRName varchar (4) VARCHAR2 (4 CHAR) varchar(4) varchar (4) true Name of the validity range (e.g. *, FREI, HON - see reference table UC_OVGB).
OVD_NotFound char (1) CHAR (1 CHAR) char(1) char (1) true Defines what happens if the key cannot be found. Abend task with an error message or return the initial value. E = eror, I = initial
OVD_OutputFormat varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Defines the output format of the value.
OVD_MinValue varchar (64) VARCHAR2 (64 CHAR) varchar(64) varchar (64) true Minimum value that is allowed.
OVD_MaxValue varchar (64) VARCHAR2 (64 CHAR) varchar(64) varchar (64) true Maximum allowed value or maximum string length that is allowed.
OVD_Uppercase smallint NUMBER(38,0) smallint smallint true Indicates whether or not the value is converted to upper case (text only).
OVD_Source varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Defines the type of the variable (e.g. STATIC, BACKEND, SEC_SQL).
OVD_ColCount smallint NUMBER(38,0) smallint smallint true Number of additional columns.
OVD_Login varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the login object used for the dynamic variable.
OVD_PrefUserLogin smallint NUMBER(38,0) smallint smallint true Indicates the the user login object is preferred over the login object defined within the variable.
OVD_Connection varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the connection object. Used for SQL and SEC_SQL variables.
OVD_PrefUserConn smallint NUMBER(38,0) smallint smallint true Indicates that the connection object from the user is preferred or not.
OVD_Sql varchar(max) CLOB varchar(4096) text true The defined SQL query that is executed on the database server.
OVD_SqlOra varchar(max) CLOB varchar(4096) text true The defined SQL query for SQLI and SEC_SQLI variables that use Oracle.
OVD_SqlDB2 varchar(max) CLOB varchar(4096) text true The defined SQL query for SQLI and SEC_SQLI variables that use DB2.
OVD_ResultFormat varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true The result format defines the result column that is added to the result set. (e.g. {1}_{2})
OVD_Vara1 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Defines the first variable used inside a MULTI variable.
OVD_Vara2 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Defines the second variable used inside a MULTI variable.
OVD_Operator smallint NUMBER(38,0) smallint smallint true Defines the merge operation (intersect) executed when resolving a MULTI variable. 0 = union, 1 = intersection, 2 = minus)
OVD_Directory varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Defines the directory whose file names are returned. (FILELIST only)
OVD_Host varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Defines the agent the variable will be executed.
OVD_PrefTaskHost smallint NUMBER(38,0) smallint smallint true Defines whether or not the agent of the task is preferred.
OVD_PrefTaskLogin smallint NUMBER(38,0) smallint smallint true Defines whether or not the agent of the login is preferred.
OVD_SortColumn smallint NUMBER(38,0) smallint smallint true Defines which column is the one which gets sorted. 0 = key, 1 = column 1, 2 = column 2, etc.
OVD_SortOrder char (1) CHAR (1 CHAR) char(1) char (1) true Defines the sort order of the column that gets sorted.
OVD_Execute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the object that will be executed. (VARA.EXEC only)
OVD_VNameResult varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the object variable that stores the result. (VARA.EXEC only)
OVD_SqlPostgres varchar(max) CLOB varchar(4096) text true The SQL-statement for Postgre

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OVD OVD_OH_Idnr true true true false
NK_OVD_Execute OVD_Execute false false false false

Foreign Keys:

Name Local References Foreign References
FK_OVD_OH OVD_OH_Idnr OH_Idnr

Return to the Index File