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)