Definition of table: OVD - variable definition

generated: 09.12.2016 10:28:52
by UC2010.accdb

AE Database 12.0 (Step 013)



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


Indexes:

Name Fields
PK_OVD OVD_OH_Idnr


Return to the Index File