https://code400.com/forum/ general questions about the database. en Sat, 16 May 2026 22:43:24 GMT vBulletin 60 images/misc/rss.png https://code400.com/forum/ https://code400.com/forum/forum/iseries-programming-languages/db2/159534-convert-data-iso-to-data-number-into-a-logical-file Fri, 01 May 2026 07:10:00 GMT Hi, I have a physical file on the AS400 that contains several fields; FIELD01 15 A FIELD02 7 A DATA01 10 L ....... I would like to create a logical file with the key Hi,
I have a physical file on the AS400 that contains several fields;

FIELD01 15 A
FIELD02 7 A
DATA01 10 L
.......

I would like to create a logical file with the key

FIELD01 K
DATA01 K

However, I need to be able to convert the DATA01 field from 10 L to 8.0 (numeric) directly within the logical file.

Is there a way to use a keyword to convert the DATA01 field from 10 (Iso) to 8.0 (numeric)?

​]]> DB2 Yanez25 https://code400.com/forum/forum/iseries-programming-languages/db2/159534-convert-data-iso-to-data-number-into-a-logical-file