HP ALLBASE/4GL FILE Logic Command [ HP ALLBASE/4GL Developer Reference Manual Vol. 1 ] MPE/iX 5.0 Documentation
HP ALLBASE/4GL Developer Reference Manual Vol. 1
HP ALLBASE/4GL FILE Logic Command
Each file operation calls one or more HP TurboIMAGE/iX library
procedures. The table overleaf outlines the HP ALLBASE/4GL FILE logic
command operations and the HP TurboIMAGE/iX library procedures called.
For library procedures that specify a mode of operation, the mode is also
listed in table 10-1.
Table 10-1. Master Data Set File Operations
----------------------------------------------------------------------------------------------
- File Operation - Library Procedure - Procedure Mode -
----------------------------------------------------------------------------------------------
- *CLOSE - DBCLOSE - 2 -
----------------------------------------------------------------------------------------------
- *DELETE - DBDELETE - 1 -
----------------------------------------------------------------------------------------------
- *FIND - DBGET - 7 -
----------------------------------------------------------------------------------------------
| *FIRST | DBCLOSE | 3 |
| | then DBGET | 2 |
----------------------------------------------------------------------------------------------
- *FIRST *KEY - DBGET - 7 -
----------------------------------------------------------------------------------------------
- *INSERT - DBPUT - 1 -
----------------------------------------------------------------------------------------------
| *MODIFY | DBUPDATE | 1 |
| | or | 1 |
| | DBPUT | 1 |
| | the DBDELETE | |
----------------------------------------------------------------------------------------------
| *LAST | DBCLOSE | 3 |
| | the DBGET | 3 |
----------------------------------------------------------------------------------------------
- *LAST *KEY - DBGET - 7 -
----------------------------------------------------------------------------------------------
| *NEXT | DBGET | 2, or 1 if migrating secondary |
| | | not processed |
----------------------------------------------------------------------------------------------
| *PREVIOUS | DBGET | 3, or 1 if migrating secondary |
| | | not processed |
----------------------------------------------------------------------------------------------
| *READ | DBGET | 7, using key indicated by *INDEXNO |
| | | or *INDEX = file operation |
| | | argument |
----------------------------------------------------------------------------------------------
- *READ *KEY - DBGET - 7 -
----------------------------------------------------------------------------------------------
- *READ *REC - DBGET - 4 -
----------------------------------------------------------------------------------------------
| *WRITE | Refer to *INSERT | |
| | or *MODIFY above. | |
----------------------------------------------------------------------------------------------
Table 10-2. Detail Data Set File Operations
----------------------------------------------------------------------------------------------
- File Operation - Library Procedure - Procedure Mode -
----------------------------------------------------------------------------------------------
- *CLOSE - DBCLOSE - 2 -
----------------------------------------------------------------------------------------------
- *DELETE - DBDELETE - 1 -
----------------------------------------------------------------------------------------------
- *FIND - DBFIND - 1 -
----------------------------------------------------------------------------------------------
| *FIRST | DBCLOSE | 3 |
| | the DBGET | 2 |
----------------------------------------------------------------------------------------------
| *FIRST *KEY | DBFIND | 1 |
| | the DBGET | 5 |
----------------------------------------------------------------------------------------------
- *INSERT - DBPUT - 1 -
----------------------------------------------------------------------------------------------
| *LAST | DBCLOSE | 3 |
| | the DBGET | 3 |
----------------------------------------------------------------------------------------------
| *LAST *KEY | DBFIND | 1 |
| | the DBGET | 6 |
----------------------------------------------------------------------------------------------
| *MODIFY | DBUPDATE | 1 |
| | or | 1 |
| | DBPUT | 1 |
| | the DBDELETE | |
----------------------------------------------------------------------------------------------
- *NEXT - DBGET - 2, or 5 for chained read -
----------------------------------------------------------------------------------------------
- *PREVIOUS - DBGET - 3, or 6 for chained read -
----------------------------------------------------------------------------------------------
| *READ | DBFIND | 1, using key specified by *INDEXNO |
| | then DBGET | or *INDEX = file operation argument, |
| | | or 5 for chained read |
----------------------------------------------------------------------------------------------
| *READ *KEY | DBFIND | 1 |
| | DBGET | 5 |
----------------------------------------------------------------------------------------------
- *READ *REC - DBGET - 4 -
----------------------------------------------------------------------------------------------
| *WRITE | Refer to *INSERT | |
| | or *MODIFY above. | |
----------------------------------------------------------------------------------------------
When an HP TurboIMAGE/iX library procedure is executed, HP TurboIMAGE/iX
returns a status array. The first halfword (16 bits) of the status array
contains the error number returned by the library procedure. The rest of
the status array contains miscellaneous information about the status of
the library procedure. The HP ALLBASE/4GL communication area field
*IOSTATDM contains the error number returned by the most recent library
procedure executed, and the *IMSTAT communication area field contains the
complete status array.
For details about the meaning of an error number or a status array, refer
to details about the particular library procedure in the HP TurboIMAGE/iX
Database Management System Reference Manual.
MPE/iX 5.0 Documentation