To show leading zeros, enter
YES
into the
Leading
zeros column. The default setting is NO (suppress leading zeros).
An example display with leading zeros shown for a column (SALARY) shows the leading zeros shown
for SALARY (but not for the other two numeric columns shown).
Figure 1 . An example display with leading zeros shown for a column (SALARY)
P rocess O ptions U tilities H elp
────────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) Table Browse 42 rows fetched
TABLE FMN USER.EMP Format TABL
JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
#8 #9 #10 #11 #12 #13 #14
CH(8) SMINT CH(1) DATE DEC(9,2) DEC(9,2) DEC(9,2)
<---+--> <---+> - <---+----> <---+----1> <---+----1> <---+----1>
**** Top of data ****
PRES 18 F 08/14/1933 0052750.00 1000.00 4220.00
MANAGER 18 M 02/02/1948 0041250.00 800.00 3300.00
MANAGER 20 F 05/11/1941 0038250.00 800.00 3060.00
MANAGER 16 M 09/15/1925 0040175.00 800.00 3214.00
MANAGER 16 M 07/07/1945 0032250.00 600.00 2580.00
MANAGER 16 F 05/26/1953 0036170.00 700.00 2893.00
MANAGER 16 F 05/15/1941 0029750.00 600.00 2380.00
⋮
Command ===> _____________________________________________________ Scroll PAGE
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Related references