Measure Reference Manual

SQLSTMT^ANSI^DESC
is the descriptor for SQLSTMT entities that supports ANSI SQL file names.
NOTE: When an ANSI SQL name is copied into the descriptor’s run^unit field, it should not
be enclosed in single quotes.
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^ANSI^desc (*)
Begin ! Used for SQL/MX ANSI SQL name run-unit
! comparisons only.
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 Version; ! Version of Sqlstmt desc; added in G11
! Use the literal sqlstmt^ANSI^desc^version
Int Stmt^index; ! statement index number within the run-unit
Int Run^unit^name^len;
Int Minimum^ANSI^Run^unit[0:63]; ! desc is at least this long...
Int Run^unit = Minimum^ANSI^Run^unit; ! up to 384 words
String Run^Unit^s = Run^unit;
End;
Definitions of the SQLSTMT^ANSI^DESC fields that differ from the SQLSTMT^DESC and
SQLSTMT^OSS^DESC descriptors follow. For definitions of all the other SQLSTMT^ANSI^DESC
fields, see SQLSTMT^DESC (page 483) and SQLSTMT^OSS^DESC (page 484).
version
INT:value:1
is the sqlstmt^ANSI^desc^version to indicate this type of descriptor.
stmt^index
INT:value:1
is the statement index number within the ANSI SQL module.
run^unit^name^len
INT:value:1
is the actual length of the ANSI SQL module name in the run^unit field.
NOTE: The ANSI SQL module name can be both shorter than and longer than 128 bytes. If
it is longer than 128 bytes, you must make sure there is memory allocated for the "extra" space.
minimum^ANSI^run^unit[0:(min^wlen^ANSI^SQLNAME - 1)];
INT:value:64
where min^wlen^ANSI^SQLNAME is 64 words, which is the minimum length of this field.
run^unit = minimum^ANSI^run^unit
is the word representation of the run unit name.
run^unit^s = run^unit
is the string representation of the run unit name.
NOTE: The run unit name can be any valid ANSI SQL module name, without enclosing single
quotes.
SQLSTMT^ANSI^DESC 485