SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—544517-008
9-28
COMPILERCONTROLS Function
COMPILERCONTROLS Function
Considerations for COMPILERCONTROLS
Examples of COMPILERCONTROLS
The COMPILERCONTROLS function is an SQL/MX extension.
The COMPILERCONTROLS function can be specified as a table reference (table) in
the FROM clause of a SELECT statement if it is preceded by the keyword TABLE and
surrounded by parentheses. The syntax for the COMPILERCONTROLS function has
no parameters. .
In a dynamic environment (that is, MXCI, MXCS, JDBC, or dynamic SQL), the
COMPILERCONTROLS function returns the active control query defaults (CQDs) and
CTDs from the SQL/MX compiler.
Considerations for COMPILERCONTROLS
Using SELECT and COMPILERCONTROLS
The SELECT statement displays the selected columns from the
COMPILERCONTROLS function:
COMPILERCONTROLS ()
Note. The COMPILERCONTROLS function is available only on systems running J06.09 and
later J-series RVUs and H06.20 and later H-series RVUs.
Column Name Type/Size Description
SeqNum Integer Organizes the attribute values that are larger than 78
characters.
Type Char(4) Indicates the type of the attribute being displayed.
Supported values are CQD, CT, CS, and CQS.
State Char(8) Indicates how the attribute is set. Supported values
are: DEF_TAB, BY_SYS, DEFAULT, BY_USER,
NOT_SET, RD_ONLY.
Attribute Char(50) Displays the name of the attribute.
Attribute_Value Char(78) Provides the value of the attribute. This column can
have actual values larger than 78 characters, where
the values will be split into chunks of 78 characters
and displayed. The SeqNum column is used to orga-
nize the chunks.
Table_Name Char(386) Populates only for the Control table type. Only the first
78 characters of the table name are displayed.