UNV_UNIVERSE
Name | Null ? | Type | Values |
UNIVERSE_ID | NOT NULL | int10 | Sequence number to identify a universe. |
UNI_FILENAME | NOT NULL | char(8) | 8 char filename |
UNI_LONGNAME | NOT NULL | char(35) | Long filename |
UNI_CONNEXION | NOT NULL | int10 | Foreign Key to OBJ_M_CONNECTION table, M_CNTN_N_ID. Identifies connection. |
UNI_VERSION | NOT NULL | int10 | Version of the universe. |
UNI_FIRSTAUTHOR | char(35) | User that created the universe. | |
UNI_LASTAUTHOR | char(35) | Last User to modify the universe. | |
UNI_CREATEDATE | char(12) | YYYY/M/D | |
UNI_MODIFYDATE | char(12) | YYYY/M/D | |
UNI_MAXTIME | NOT NULL | int10 | Time in seconds to "Limit execution time to:" |
UNI_MAXLINES | NOT NULL | int10 | Number of rows to "Limit size of result set to:" |
UNI_ESTIMATE | int10 | Time in seconds for "Limit cost estimate time to:" | |
UNI_MAXCOLUMN | int6 | Number of characters to "Limit size of long text objects to:" | |
UNI_PREFERENCES | char(35) | A coded
field for the check boxes on the "controls" and
"SQL" tabs. Values are Y or N. position 1
"SQL" query - Allow use of subquery position 2 "SQL" query - Allow use of Union, intersect and minus position 3 "SQL" query - Allow complex operators in Query Panel. position 4 "SQL" multiple paths - Multiple SQL statements for each context. position 5 "SQL" multiple paths - Allow selection of multiple contexts. position 6 "SQL" Catesian Products. Prevent =Y, Warn =N position 7 "Controls" Limit size of result set: position 8 "Controls" Limit Size of long text objects to: position 9 "Controls" Limit execution time to: position 10 "Controls" Warn if cost estimate exceeds: position 11 "SQL" multiple paths - multiple SQL statements for each measure. |
|
UNI_CONVERSION | int1 | ||
UNI_REPODOCID | int10 | ||
UNI_QUALIFIERS | char(35) | ||
UNI_OWNERS | char(35) |