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