SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-31
Formatting Data Values
Table 4-1. Default Display Formats (page 1 of 2)
SQL Data Type Default Display Format
Fixed-length Characters: An (or A255 if n > 255)
CHAR(n)
PIC X(n) DISPLAY
NATIONAL CHAR(n)
NCHAR(n)
Variable-length Characters:
VARCHAR(n)
NATIONAL CHARACTER
VARYING (n)
NCHAR VARYING(n)
NUMERIC(1,s) — NUMERIC (4,s) I6 (or F7.s if s > 0)
NUMERIC(1,s) UNSIGNED — I5 (or F6.s if s > 0)
NUMERIC(4,s) UNSIGNED
NUMERIC(5,s) — NUMERIC(9,s) I11 (or F12.s if s > 0)
NUMERIC(5,s) UNSIGNED — I10 (or F11.s if s > 0)
NUMERIC(9,s) UNSIGNED
NUMERIC(10,s) — NUMERIC(18,s) I20 (or F21.s if s > 0)
DECIMAL (n,s) In+1 (or Fn+2.s if s > 0)
DECIMAL (n,s) UNSIGNED In (or Fn+1.s if s > 0)
PIC S9(i) [V9(s)] Ii+1 (or Fi+2.s if s > 0)
PIC 9(i) [V9(s)] Ii (or Fi+1.s if s > 0)
PIC SV9(s) Fs+2.s
PIC V9(s) Fs+1.s
FLOAT (where precision is 1 through
22)
E14.7
FLOAT (where precision is 23 through
54)
E24.17
REAL E14.7
DOUBLE PRECISION E24.17