OBJ_M_UNIVCST
Universe parameters redefinition (part 1/2): relates to connection overload, SQL overloads and control overloads.
Name | Null ? | Type | Values |
M_UNIC_N_UNILINKID | NOT NULL | int10 | Foreign key to obj_m_reslink.m_res_n_id |
M_UNIC_C_LONGNAME | NOT NULL | char(35) | Not Used |
M_UNIC_N_CNTID | NOT NULL | int10 | Foreign key to the connection ID obj_m_connection.m_cntn_n_id |
M_UNIC_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_UNIC_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_UNIC_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_UNIC_N_ITEMLEN | NOT NULL | int10 | Maximum size of a long text object that a user can retrieve from the database |
M_UNIC_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_UNIC_N_HELPSLCID | NOT NULL | int10 | Foreign key to obj_m_univslc.m_unis_n_id (not used) |
M_UNIC_N_LAD | NOT NULL | int10 | Last Action Date |
M_UNIC_N_LAT | NOT NULL | int10 | Last Action Type |