Measure Reference Manual

Usage Note for G-Series PVUs
In Measure G12 and later PVUs, code-space identifiers are displayed only for TNS code files
(including accelerated TNS code files).
Examples
• To display all report attributes:
+ SHOW REPORT
Set Report Format normal
Set Report Rate on
Set Report Totals suppress
Set Report Zero-Values suppress
Set Report Zero-Reports suppress
Set Report From
Set Report For
Set Report LoadId
Set Report CR-NAME-LEN short
Set Report CR-NAME-FORM standard
Set Report CR-NAME-QUAL unqualified
• To display the current value of the CR-NAME-LEN only:
+ SHOW REPORT CR-NAME-LEN
Set Report CR-NAME-LEN short
SQLCATALOG
In Measure H01 and later PVUs, the SQLCATALOG command specifies a default catalog for use
in expanding partially qualified ANSI SQL names.
Syntax
SQLCATALOG [ ’catalog-name’ ]
catalog-name
is an ANSI SQL catalog identifier. If catalog-name is not specified, the default empty value
is used.
Example
To specify a default catalog for expanding partially qualified ANSI SQL names:
+ SQLCATALOG ’CATALOG_12’
SQLSCHEMA
In Measure H01 and later PVUs, the SQLSCHEMA command specifies a default schema, and
optionally a default catalog, for use in expanding partially qualified ANSI SQL names.
Syntax
SQLSCHEMA [ ’[catalog-name.]schema-name’ ]
catalog-name
is an ANSI SQL catalog identifier. If no default catalog is specified and there is no previous
default catalog, a warning message is displayed.
schema-name
is an ANSI SQL schema identifier.
If neither catalog-name nor schema-name is specified, the default empty value is used.
SQLCATALOG 119