Very wird problem...

[Guest.Visitor]

Hello! I have a questions that until this moment I didnt found any answer. Suppose that I want to see the contents of a PF (physical file). I can use two common ways (among others),the DSPPFM or the RUNQRY. The wird is that they give different results. The "DSPPFM PF" says that there arent any records in the PF meanwhile when I use the "RUNQRY () PF" I see six records and besides that the status message that appears says that -1880 (negative number,althougt the DSPFD says that there are 1880 (positive) records in the file) where selected by the query. Meanwhile I decided to make a RGZPFM and it fixed the problem. But just for a while because now the same problem is happening again. Does anybody had faced this problem before or have any clue about what can be causing it ? I need to fix it urgently :( TIA, Silvio.

[David Abramowitz]

Here are a few possibilities:<ul> You are not looking at the bottom of the DSPFD display where deleted records are listed. You have a multi-member physical file, where each member has a different number of records. You are accessing different files in different libraries with the same file name.[/list] I suggest that you look at where and how this file is used. I have a hunch that records are constantly being deleted and added, and reorgs are rare. Dave

[Guest.Visitor]

When the AS/400 deletes records from a physical file, it doen't actually remove the record from the file...it just "marks" it for deletion. The records still take up space and are reported in the record count when using AS/400 commands, like you used. When you RGZPFM (reorganized the file) the records are removed from the file (space they used is now available to the system) and record counts are updated to show only actual physical records left in the file. Best Regards Jerry Robison To code RPG code on a PC see.. http://members.nbci.com/breckop/SEUindex.html

[Guest.Visitor]

Jerry! I agree with you. But How do you explain the difference between DSPPFM and RUNQRY ? And also the negative number ? Silvio.