SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-1
V
VARCHAR_WIDTH Option
VARCHAR_WIDTH is an option of the SQLCI report writer SET STYLE command that
specifies the maximum number of single-byte characters the report writer can display
in a print item of a varying-length character data type.
number
is an integer in the range 1 through 255 that specifies the maximum number of
single-byte characters that can appear in the print item. The default is 80.
Consideration—VARCHAR_WIDTH
You can override the VARCHAR_WIDTH setting by using the Cn display descriptor in
an AS clause for a print item. For information, see AS Clause on page A-60.
You must override VARCHAR_WIDTH to print varying-length character items with
more than 255 bytes. For example, you can use AS C0.40 to print a VARCHAR item
that contains 1000 single-byte characters (or 500 multibyte characters). The value
prints on multiple lines in 40-byte fields.
Example—VARCHAR_WIDTH
This example sets a VARCHAR_WIDTH of 60 (60 single-byte characters or 30
multibyte characters):
>> SET STYLE VARCHAR_WIDTH 60;
VERIFIEDWRITES File Attribute
VERIFIEDWRITES is a file attribute that specifies or inhibits a verification disk read
after each disk write. VERIFIEDWRITES applies to key-sequenced, relative, and
entry-sequenced files, in addition to indexes.
The table default is NO VERIFIEDWRITES. The index default is its table's value at
index creation.
VARCHAR_WIDTH number
{ VERIFIEDWRITES | NO VERIFIEDWRITES }