Measure Reference Manual

run^unit
INT:value:32
is the name of the procedure that contains the SQL statement to measure. To include all run
units, the name of the procedure should be blank-filled. Do not use the asterisk (*) wild-card
character.
Not used for ANSI SQL.
stmt^index
INT:value:1
is the statement index number within the specified run unit (procedure).
Not used for ANSI SQL.
run^unit^s
is the string representation of the run unit name.
SQLSTMT^OSS^DESC
is the descriptor for SQLSTMT entities that supports OSS file pathnames, SQL/MP procedures, or
SQL/MX modules.
NOTE: When the measurement is being configured, only the process part of the descriptor is
used; when performing a listing, all the fields can be used.
Struct Sqlstmt^OSS^desc (*);
Begin
Int Type; ! Entity type
Int Len; ! Byte length of record.
Int CPU^number;
Int PIN;
Int Process^name[0:3];
Int Program^file^name[0:11];
Struct Program^file^name^MID; ! Internal identifier for OSS pathname
Begin
Int Pathid[0:11]; ! Internal format OSS file pathname
Int Crvsn[0:2]; ! Creation Volume Sequence Number
End;
Int Run^unit[0:63]; ! procedure or run-unit name
Int Stmt^index; ! statement index number within the run-unit
String Run^Unit^s = Run^unit;
End;
Definitions of the SQLSTMT^OSS^DESC fields that differ from the SQLSTMT^DESC descriptor
follow. For definitions of all other fields, see SQLSTMT^DESC (page 483).
PROGRAM^FILE^NAME^MID
is a structure that contains the internal-format file name for the OSS pathname.
pathid
INT:value:12
is the internal format representation of an OSS file pathname for the specified program file
name. To indicate all PATHIDs, initialize PATHID[0] to -1.
crvsn
INT:value:3
is the creation version serial number that identifies a unique instance of an OSS disk file.
To indicate all CRVSN values, initialize CRVSN[0] to -1.
484 Entity Descriptors