© Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide: 9   4/2/2002
Transformations
•Sometimes, the data on the AS/400 is not the data you want on the client
–Example, Java does not like Decimal as they are an immutable type. If the target needs to manipulate the data, plan on doing a cast in the select statement to a better numeric type
–Decimal(3,0) might map to smallint
–Decimal(12,2) might map to double
–Decimal(6,0) might map to integer