We have a MetaCOBOL+ application program that does a "LOCATE PHYSICAL" on three tables in a Datacom/DB Database that has six Areas. It does an "OBTAIN PHYSICAL" on only the table with the largest record length of the three tables because it uses that record length as a template to put the other two tables in and then writes out any one of the three tables once it finds the record it wants.
We added a 4th table to this program but are unable to select/find any records on this new table, even though we know we have thousands of records. Do all tables have to be in the same physical "Area" of a Database to do a "Locate/Obtain Physical?
LOCATE PHYSICAL and OBTAIN PHYSICAL are Metacobol statements. The related Datacom/DB commands are respectively GSETP and GETPS.
LOCATE and OBTAIN PHYSICAL as well as other Metacobol statements can be found in MetaCOBOL+ Program Development Reference DATACOM/DB.
Their corresponding Datacom/DB commands can be found in the Appendix A for same manual.
More information on these commands can be found in the respective techdoc sections: GETPS and GSETP .
All the tables have to be in the same physical Area of a Database to do a "Locate/Obtain Physical".