NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
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.
Considerations—VARCHAR_WIDTH
•
Overriding VARCHAR_WIDTH
You can override the VARCHAR_WIDTH setting by using the C n display
descriptor in an AS clause for a print item. (See AS Clause
on page A-54 for
details.)
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.
Examples—VARCHAR_WIDTH
•
The following command 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, as well as 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 }