Measure Reference Manual

executes them. In SQL/MX, however, SQL procedures and modules are compiled and stored
separately from the program object file that executes them.
In Measure G11 and later PVUs, the SQLSTMT entity displays ANSI SQL names in SQLSTMT
reports.
In Measure H01 and later PVUs, MEASCOM LIST commands accept ANSI SQL/MX release 2
module object names (run unit names) in SQLSTMT entity specifications.
SQL/MX module names (previously called run unit names), can be:
Length (In Characters)Measure PVUs
Up to 128G10 and earlier
Up to 784G11 and later
If specific module names are not specified in SQL/MX, a system-generated name based on the
Julian timestamp at the time of preprocessing will be assigned. For information regarding the
naming and indexing of statements in SQL/MX modules, see the preprocessor output file.
PageTopic
342Entity specification syntax for SQLSTMT entities
344DDL records for SQLSTMT entities
347DDL field definitions for SQLSTMT entities
352Usage notes for SQLSTMT entities
353Example of SQLSTMT measurement
Entity Specification Syntax for SQLSTMT Entities
To describe SQLSTMT entities:
SQLSTMT entity-spec [,entity-spec] ...
SQLSTMT
collects information about SQL statements within the SQL process.
entity-spec
For the ADD and DELETE commands, specify entity-spec as:
{ * }
{ $process-name [ ( pid ) ] }
{ disk-filename [ ( pid ) ] }
{ pid }
For the LIST and LISTALL commands, specify entity-spec as:
{ * ["run unit"[,#index]] }
{ * ["run-unit"[[Index]#index]] }
{ $process-name [ ( pid ) ] ["run-unit"[,#index]] }
{ $process-name [ ( pid ) ] ["run-unit"[Index]#index]] }
{ disk-filename [ ( pid ) ] ["run-unit"[,#index]] }
{ disk-filename [ ( pid ) ] ["run-unit"[[Index] #index]] }
{ "pname" [ ( pid ) ] ["run-unit"[,#index]] }
{ "pname" [ ( pid ) ] ["run-unit"[[Index] #index]] }
{ pid ["run-unit"[,#index]] }
{ pid ["run-unit"[[Index] #index]] }
For the LISTACTIVE command, specify entity-spec as:
{ $process-name ( pid ) "run-unit", #index }
{ $process-name ( pid ) "run-unit" [Index] #index }
342 Entities and Counters