Hello everybody!
Using the SQL command on the physical data file, a view was created that selects records under certain conditions. Further, through the QUSRMBRD API, information about the (single) member was retrieved. Among the extracted information is information about the number of records. By condition, view selects 1 entry, but there are 6 entries in the information about the number of entries (total number of entries in the physical file). Why it happens? How to fix it?
Postscript: Perhaps this question should have been asked not in this forum thread ...
Using the SQL command on the physical data file, a view was created that selects records under certain conditions. Further, through the QUSRMBRD API, information about the (single) member was retrieved. Among the extracted information is information about the number of records. By condition, view selects 1 entry, but there are 6 entries in the information about the number of entries (total number of entries in the physical file). Why it happens? How to fix it?
Postscript: Perhaps this question should have been asked not in this forum thread ...
Comment