13.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 IBM i version considerations. Refer to the IBM manual Data Description Specifications, keyword DDS, RPG/400 and/or ILE RPG for AS400 Reference Edit Codes section.

* Note that Y is a special date edit code and Z is a special sign removal edit code.