SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-54
SHOW STYLE Command
SHOW STYLE Command
SHOW STYLE is an SQLCI report writer command that displays the current style
options. Style options affect the appearance of specific report items, such as
underlines, headings, and date and time formats.
* displays all style options.
For information about a specific option, see the entry for that option.
Example—SHOW STYLE
This example displays the current setting for three style options:
>> SHOW STYLE NEWLINE_CHAR, OVERFLOW_CHAR, UNDERLINE_CHAR;
NEWLINE_CHAR @
OVERFLOW_CHAR *
UNDERLINE_CHAR _
Similarity Checks
A similarity check is a comparison made by SQL to determine whether two objects (or
the compile-time and execution time version of the same object) are sufficiently similar
that a serial execution plan compiled for one is also an operable plan for the other.
(SQL does not perform similarity checks for objects referenced in parallel execution
plans.)
You can reduce recompilation time for an application by directing the SQL compiler to
recompile only plans that are actually inoperable, not merely invalid. If you do so, the
SQL compiler uses similarity checks to determine whether certain invalid plans (those
that are invalid because objects they reference have been changed or redefined) are
actually operable plans.
SHOW { [ STYLE ] option [, option ] ... } ;
{ STYLE * }
option is:
{ DATE_FORMAT }
{ DECIMAL_POINT }
{ HEADINGS }
{ NEWLINE_CHAR }
{ NULL_DISPLAY }
{ OVERFLOW_CHAR }
{ ROWCOUNT }
{ SUBTOTAL_LABEL }
{ TIME_FORMAT }
{ UNDERLINE_CHAR }
{ VARCHAR_WIDTH }