| 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 |