Measure Reference Manual

SQLSTMT^DESC
is the descriptor for SQLSTMT entities.
For OSS file pathnames, use SQLSTMT^OSS^DESC (page 484).
For ANSI SQL file names, use SQLSTMT^ANSI^DESC (page 485).
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^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]
Int Run^unit[0:15]; ! procedure or run-unit name
Int Stmt^index; ! statement index number within the run-unit
String Run^Unit^s = Run^unit;
End;
type
INT:value:1
is the literal SQLSTMT^T or the numeric identifier 16.
A positive type value includes the specified entities in the measurement configuration. A
negative type value excludes the specified entities from measurement. For an example, see
Specifying Entity Descriptors (page 376).
len
INT:value:1
is the length in bytes of this descriptor. len is 74.
cpu^number
INT:value:1
is the number of the CPU on which the process to be measured is running.
pin
INT:value:1
is the process identification number of the process to be measured. You can use these literal
values:
• -1 to indicate all processes
• SYSPROCS to indicate all processes installed by SYSGEN
process^name
INT:value:4
is the name of the process to be measured. The name must be left-justified and blank-filled. It
must consist of a dollar sign ($) followed by a process name in internal format. To indicate all
processes, use a dollar sign and an asterisk ($*).
program^file^name
INT:value:12
is the name of the object file that the process to be measured is executing. The name must be
left-justified, blank-filled, and in local internal format. You can use asterisks (*) in the volume,
subvolume, and file-name fields within file^name. However, the volume name must begin
with a dollar sign ($). For example, to specify all program file names, use the value "$* * *".
SQLSTMT^DESC 483