As400/DB2

How to check existance of record without using file opcodes

By using INFDS and standard fields *FILE/*RECORD.... how to find out a record existance in Physical File without using any file opcode? Please tell me the RPG code how to use it, not only the I spec definition. Software/Hardware used: Iseries

Delete OLD files from Table not having date or timestamp

Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...