SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
O-10
OVERFLOW_ CHAR OPTION
OVERFLOW_ CHAR OPTION
OVERFLOW_CHAR is an option of the SQLCI report writer SET STYLE command that
specifies the default filler character to print when the value of a numeric report item is
too large for its display format.
character
is a printable, single-byte character to use as an overflow character.
The default is *.
Consideration—OVERFLOW_CHAR
You can override the default filler character for a specific print item by specifying the
OC modifier in the display format for the item. For more information, see AS Clause on
page A-60.
Example—OVERFLOW_CHAR
If you enter this command option, a value that is too large for a 10-byte display field
prints as “++++++++++”:
>> SET STYLE OVERFLOW_CHAR "+";
OWNER FILE ATTRIBUTE
OWNER is a file attribute that identifies the owner of the file. OWNER applies to tables,
indexes, protection views, collations, catalogs, programs, and Guardian files.
group-num, user-num
specifies the user ID of the user who is to be given ownership of the object;
group-num is an integer that is a group number; user-num is an integer that is a
user number.
The table default is the user ID of the creating process.
The index default is the user ID of the table's owner.
For more information about file ownership, see Security on page S-11.
OVERFLOW_CHAR “character”
OWNER group-num, user-num