OBJ_M_UNIVERSES
Name | Null ? | Type | Values |
M_UNI_N_ID | NOT NULL | int10 | Primary key, see obj_m_magicid , 'UNIVERSE' row. |
M_UNI_N_REPOID | NOT NULL | int10 | ID of the universe domain in which the universe is stored (table OBJ_M_REPOSITORY, row M_REPO_N_ID) |
M_UNI_C_FILENAME | NOT NULL | char(14) | Short name of the universe: as stored on the file system when imported, with a .unv extention |
M_UNI_C_LONGNAME | NOT NULL | char(35) | Long name of the universe: entered as a universe parameter. |
M_UNI_N_REVISION | NOT NULL | int10 | Revision number, increased by each export. |
M_UNI_N_LUT | NOT NULL | int10 | Last Update Time: current date during the last export. |
M_UNI_N_LOV | NOT NULL | int10 | Number of LOVs associated to the universe (or, alternatively, number of objects of the universe with an associated LOV) |
M_UNI_N_HELPSLCID | NOT NULL | int10 | Foreign Key to OBJ_M_UNISLC.M_UNIS_N_ID (which stores a help field for the universe) |
M_UNI_N_CNTID | NOT NULL | int10 | Foreign key to OBJ_M_CONNECTION.M_CNTN_N_ID (which stores a connection on which the universe relies) |
M_UNI_N_MAXLINE | NOT NULL | int10 | The value is the maximum number of rows that a query can retrieve from a database. When the query reaches this limit, it stops; however, the end user can still retrieve the partial results. |
M_UNI_N_MAXTIME | NOT NULL | int10 | Time such that if the execution exceeds this limit, the query stops; however, the user can retrieve the partial results. |
M_UNI_N_WARNTIME | NOT NULL | int10 | This option applies only to RDBMS with cost estimate features based on time. It causes a warning message to appear if the cost estimate exceeds the number of minutes you specify. |
M_UNI_N_ITEMLENGTH | NOT NULL | int10 | Maximum size of a long text object that a user can retrieve from the database |
M_UNI_C_FLAGS | NOT NULL | char(20) |
A coded field for the check boxes on the "controls" and "SQL" tabs. Values are Y, N or U. Y is for checked, N for unchecked and U for unused (keep the universe value). From left to right: 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" Cartesian 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. position 12-20: reserved. |
M_UNI_N_LOCKER | NOT NULL | int10 |
0: Unlocked UserId: Locked by user of ID UserID (foreign key to OBJ_M_ACTOR.M_ACTOR_N_ID). The user must be a designer. |
M_UNI_N_LAD | NOT NULL | int10 | Last Action Date |
M_UNI_N_LAT | NOT NULL | int10 | Last Action Type |