SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-20
Example—RESET STYLE
* resets all style options to their default settings.
For more information, see the entries for individual options.
Example—RESET STYLE
This example resets the DECIMAL_POINT and NEWLINE_CHAR options:
>> RESET DECIMAL_POINT, NEWLINE_CHAR;
RESETBROKEN File Attribute
RESETBROKEN is a file attribute that resets the file-label BROKEN flag for a file.
RESETBROKEN applies to key-sequenced, relative, and entry-sequenced tables and
to indexes. However, you cannot alter the RESETBROKEN attribute for catalog tables.
When you reset the BROKEN flag, it does not invalidate dependent programs.
RIGHT_MARGIN Option
RIGHT_MARGIN is an option of the SQLCI report writer SET LAYOUT command that
sets the right margin for the current report and for all subsequent reports until you reset
the margin.
number
is an integer in the range 1 through 255 that indicates the right most byte position
in the report line. number must be greater than the LEFT_MARGIN layout option.
The default is the width of the output device.
NEWLINE_CHAR /
NULL_DISPLAY ?
OVERFLOW_CHAR *
ROWCOUNT ON
SUBTOTAL_LABEL *
TIME_FORMAT HP2:M2:S2
UNDERLINE_CHAR -
VARCHAR_WIDTH 80
RESETBROKEN
RIGHT_MARGIN number