| OVD_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
reference to the object header (OH) |
| OVD_Type |
varchar (2) |
VARCHAR2 (2 CHAR) |
varchar(2) |
true |
type of the variable |
| OVD_VRName |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
name of the validity range (reference to table UC_OVGB) |
| OVD_NotFound |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
E=error,I=initial |
| OVD_OutputFormat |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
true |
Output Format of the value at time of access |
| OVD_MinValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
true |
Min allowed value |
| OVD_MaxValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
true |
Max allowed value or string length |
| OVD_Uppercase |
smallint |
NUMBER(38,0) |
smallint |
true |
Convert value to upper-case (Strings only) |
| OVD_Source |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Var-Type Definition |
| OVD_ColCount |
smallint |
NUMBER(38,0) |
smallint |
true |
Number of additional columns |
| OVD_Login |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
UC4 login-object for the database connection (SQL, FileList) |
| OVD_PrefUserLogin |
smallint |
NUMBER(38,0) |
smallint |
true |
Use the login-object stored in the user-object or the database connection (SQL) |
| OVD_Connection |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
UC4 connection-object with parameters for the database connection (SQL) |
| OVD_PrefUserConn |
smallint |
NUMBER(38,0) |
smallint |
true |
Use the connection-object stored in the user-object for the database connection (SQL) |
| OVD_Sql |
varchar(max) |
CLOB |
varchar(4096) |
true |
The SQL-statement for MS-SQL-Server and default if the other DBMS-specific statements are not defined |
| OVD_SqlOra |
varchar(max) |
CLOB |
varchar(4096) |
true |
The SQL-statement for Oracle |
| OVD_SqlDB2 |
varchar(max) |
CLOB |
varchar(4096) |
true |
The SQL-statement for DB2 |
| OVD_ResultFormat |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
Format of the result of SQL-statement (e.g. {1}_{2}) |
| OVD_Vara1 |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
1st variable to be merged (MULTI) |
| OVD_Vara2 |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
2nd variable to be merged (MULTI) |
| OVD_Operator |
smallint |
NUMBER(38,0) |
smallint |
true |
Merge-operation to be performed on Vara1 and Vara2. (0=Union, 1=Intersection, 2=Minus) |
| OVD_Directory |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
Directory whose filenames are returned as result (FileList) |
| OVD_Host |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Agent which performs the search (FileList) |
| OVD_PrefTaskHost |
smallint |
NUMBER(38,0) |
smallint |
true |
Use the same agent as the task which uses the variable (FileList) |
| OVD_PrefTaskLogin |
smallint |
NUMBER(38,0) |
smallint |
true |
Use the same login as the task which uses the variable (FileList) |
| OVD_SortColumn |
smallint |
NUMBER(38,0) |
smallint |
true |
Column to sort by (0: key, 1: column 'value1', 2: column 'value2', 3: column 'value3', 4: column 'value4') |
| OVD_SortOrder |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
Sort order (A: Asc, D: Desc) |
| OVD_Execute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Name of the object that will be executed. (VARA.EXEC only) |
| OVD_VNameResult |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
true |
Name of the object variable that stores the result. (VARA.EXEC only) |