How to get a specific record based on the actual physical record location number

[Guest.Visitor]

select * from file where RRN(file)=record number

[ACT]

How to get a specific record based on the actual physical record location number

How to get a specific record based on the actual physical record location number of the file using SQL.

[asheesh_ks@infosys.com]

How to get a specific record based on the actual physical record location number

If you are using RPG, define the file as non-keyed. Now you can chain the file with RRN. e.g. /free chain 123 filename; If %found; .....do something; EndIf /end-free However, if the file is keyed, you need to use RECNO keyword in File declaration.