12.3 Standard Field Edit Codes
Field Edit Codes are stored in the Repository and are used to return your data in the format required by the application.
If your output is not in the format expected, you may simply need to change the edit code in order to fix it.
Code |
Commas |
Decimal Point |
Leading Zero Suppression |
Zero Balance |
Type of Sign used |
Position |
1 |
Y |
Y |
Y |
Y |
None |
|
2 |
Y |
Y |
Y |
|
None |
|
3 |
|
Y |
Y |
Y |
None |
|
4 |
|
Y |
Y |
|
None |
|
A |
Y |
Y |
Y |
Y |
CR |
Trailing |
B |
Y |
Y |
Y |
|
CR |
Trailing |
C |
|
Y |
Y |
Y |
CR |
Trailing |
D |
|
Y |
Y |
|
CR |
Trailing |
J |
Y |
Y |
Y |
Y |
- |
Trailing |
K |
Y |
Y |
Y |
|
- |
Trailing |
L |
|
Y |
Y |
Y |
- |
Trailing |
M |
|
Y |
Y |
|
- |
Trailing |
N |
Y |
Y |
Y |
Y |
- |
Leading |
O |
Y |
Y |
Y |
|
- |
Leading |
P |
|
Y |
Y |
Y |
- |
Leading |
Q |
|
Y |
Y |
|
- |
Leading |
W ** |
|
|
|
|
|
|
Y * |
|
|
Y |
|
|
Y |
Z * |
|
|
Y |
|
|
|
** Note that W is a special date edit code with i5/OS version considerations. Refer to the IBM manual
, keyword DDS, RPG/400 and/or section.* Note that Y is a special date edit code and Z is a special sign removal edit code.