SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-62
Printing Double-Byte Characters
Using Display Descriptors with Double-Byte Characters
Display descriptors, specified by the AS clause, define the display format for print
items.
A[
w] specifies an alphanumeric field with a display width of w print positions. If w is
omitted, the width of the print item is used. If the print item is smaller than
w, the item is
left-justified with blank fill. If
w is too small for the value, the value is truncated.
C
n.[w] specifies the format for long character fields such as VARCHAR fields. The n
specifies the number of print positions to print or display. If n is 0, the entire field is
printed. The
w specifies the number of print positions per line. If you do not include w,
the C format is the same as the A format.
There are two scenarios in which display descriptors can split double-byte characters:
•
The width of the display descriptor is odd-numbered
•
The width of the display descriptor is too small
Figure 4-26. Using the TAB Clause to Adjust Display Columns
Note. The same wrapping, or the same folding, can occur for print lines generated for the
other report writer commands, such as REPORT TITLE, REPORT FOOTING, PAGE TITLE,
AND PAGE FOOTING. Use the SPACE or TAB clauses as required to adjust spacing if double-
byte characters are being split.
VST0426.vsd
c1c2c3c4c5c6c7
DEPTNUM DEPTNAME MANAGER RPTDEPT LOCATION
1000
1500
FINANCE
PERSONNEL
INVENTORY2000
23
213
32
9000
1000
9000
c1c2
c1c2c3c4c5
>>S
TAB 30
TAB 41
2 spaces
(default)
>>SET LIST_COUNT 0;
>>SELECT
* FROM PERSNL.DEPT;
>>S
S>SET RIGHT_MARGIN 55;
S>DETAIL col1, col2, tab 30, col3, tab 41 col4, col5;
S>L F 3;