© Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide: 11   4/2/2002
Transformations
•Dates may be in a legacy format
–Example: a system stores an invoice date as DECIMAL(2,0) Century, DECIMAL(2,0) Year, DECIMAL(2,0) Month and DECIMAL(2,0) Day.
–If the client intends to manipulate the value as a date, do the transformation on the 400 prior to sending the data to the client
–Some clients can not understand the full range of an AS/400 date, fix up these dates before sending to the client