Measure Reference Manual

• Measure compresses any white space (one or more blanks) within single quotes that is not
within double quotes.
• Measure wraps displayed ANSI SQL names from one line to the next, as needed. If you cut
and paste a wrapped ANSI SQL name from a Measure display, carriage return characters
might be included that are not part of the name. To avoid this, cut and paste the name one
line at a time.
• To enter commands longer than 132 characters, continuation characters (“&”) must be used
to break the command input lines into smaller pieces. Entering a text string terminated by the
ampersand character will cause the next input line to be treated as a continuation of the input.
Successive input lines entered in this fashion are treated as if they were entered as one string.
For example:
+ ADD DISKFILE ‘long_long_long_long_long_long_long_long_&
& long_catalog.short_schema.short_object PARTITION&
& short_partition2’
• ANSI SQL identifiers can be long (up to 128 characters). The maximum length of an identifier
in delimited form is 258 characters (two double-quotes to delimit the identifier, plus 256
double-quote characters to express an identifier consisting of 128 double-quote characters).
◦ An ANSI SQL object name without a name space qualifier has a maximum undelimited
length of 386 characters (three undelimited identifiers of 128 characters plus two periods).
In delimited form, an object name has a maximum length of 776 characters (three delimited
identifiers of 258 characters, plus two periods).
◦ An ANSI SQL object name with a name space qualifier has a maximum undelimited
length of 393 characters (7 additional characters for the MODULE keyword, plus a
space). In delimited form, an object name has a maximum length of 783 characters (7
plus 776).
◦ An SQL/MX partition name without a name space qualifier has a maximum undelimited
length of 525 characters (four undelimited identifier fields of 128 characters, plus two
periods, plus nine characters for the PARTITION keyword, plus two spaces). In delimited
form, a partition name has a maximum length of 1045 characters (four delimited identifiers
of 258 characters, plus two periods, plus nine characters for the PARTITION keyword,
plus two spaces).
◦ An SQL/MX partition name with a name space qualifier has a maximum undelimited
length of 531 characters (6 additional characters for the TABLE or INDEX keyword
followed by a space). In delimited form, a partition name has a maximum length of 1051
characters (6 plus 1045).
◦ The maximum ANSI SQL name length is 1051 characters for a maximum length partition
name expressed in delimited form.
SQL/MX does not support all of these theoretical limits. And when SQL/MX returns a syntax
error, Measure reports a syntax error. See the SQL/MX Reference Manual.
SQL Journal Segment
A measurement data file can include the SQL journal segment for use in translating between ANSI
SQL, Guardian names, and ANS UIDs. The SQL journal segment ensures portability of SQL name
translation between systems and over time.
The journal segment includes information such as the SQL/MX object and partition names, Guardian
name, ANS UIDs, ANSI name space, and SQLMID (an internal Measure handle that represents a
particular instance of the SQL/MX file).
SQL journal segment construction is not required when you analyze Measure data on the system
where the measurement occurred. SQL journal segment construction is required when name
150 Entities and Counters