IBM i DDS Edit Codes 

 December 5, 2008

By  NickLitten

AS400 iSERIES and IBM i DDS Cheat Sheet

You can use data description specifications (DDS) to create a file.

Edit Code Description No Sign CR Sign -Sign(R) -Sign(L)
Commas and zero balances 1 A J N
Commas 2 B K O
Zero balances 3 C L P
No commas or zero balances 4 D M Q
User-defined edit codes 5 – 9
Hexadecimal F sign X1
Date edit Y2
Suppress leading zeros Z3

IBM i DDS Edit Codes 1Notes:

  1. The X edit code ensures a hexadecimal F sign for positive values. Because the system does this for you, normally you do not have to specify this code.
  2. The Y edit code suppresses the leftmost zeros of date fields, up to, but not including the digit preceding the first separator. The Y edit code inserts slashes (/) between the month, day, and year according to the following pattern (with zero suppression):
  3. nn/n nn/nn nn/nn/n nn/nn/nn nnn/nn/nn nn/nn/nnnn nnn/nn/nnnn nnnn/nn/nn nnnnn/nn/nn
  4. The Z edit code removed the sign (plus or minus) from a numeric field and suppresses leading zeros.


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Get In Touch

I’m always looking for awesome input, feedback and critique!


Snug CBD

 20% Discount

I have partnered with SNUG CBD givING you Organic CBD
20% discount code "NL20"