https://code400.com/forum/ Discussions on various languages used on the IBM Iseries. en Tue, 12 May 2026 16:22:47 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 https://code400.com/forum/forum/iseries-programming-languages/rpg-rpgle/159531-how-to-find-wich-program-lock-file-record Wed, 01 Apr 2026 20:43:43 GMT Hi all
In a job, sometimes I have a problem with a record that remain locked and so i get CPF5032 "Record already locked to this job ;
how i could find the program that take locked the record ??
Keep in mimd that this file is under commitment control ..
Thank in advance

​]]> RPG/RPGLE gio.cot https://code400.com/forum/forum/iseries-programming-languages/rpg-rpgle/159531-how-to-find-wich-program-lock-file-record