Database Functions

The following database I/O functions are available.

For more information, see Doc for Developers: Lawson RPG Application Program Interfaces.

File-Level Functions

Function Description
E@DBCREATE Use to initialize the record area in preparation for adding a new record.
E@DBRECREATE Use to populate the record area with values based on an existing records, in preparation for adding a new record.
E@DBSTORE Use to add a new record.
E@DBDELETE Use to delete individual records.
E@DBFULLDELETE Use to delete a single record from a table and its related records according to the delete rules.

Find Functions

Function Description
E@DBFINDEQ Use to find a single record where all key field values are specified.
E@DBKFNDEQ Use to return the keys of single record.
E@DBFINDGE Use to read a record whose key field is greater than or equal to the specified values.
E@DBKFNDGE Use to return the key values of the record whose key field is greater than or equal to the specified values.
E@DBFINDNXT Use to read the record following the current record.
E@DBKFNDNXT Use to return the key field values of the next record.
E@DBFINDPRV Use to read the record previous to the current record
E@DBFINDBEGRNG Use to retrieve the first record in a range when you want to process a range of data.
E@DBKFNDBEGRNG Use to retrieve the keys of the first record in a range.
E@DBFINDSUBRNG Use to retrieve the first record in a subrange.
E@DBKFNDSUBRNG Use to retrieve the keys of the first record in a subrange.
E@DBFINDNXTRNG Use to find the next record in a range.
E@DBKFNDNXTRNG Use to retrieve the keys of the next record in a range.
E@DBFINDPRVRNG Use to find the previous record in a range.
E@DBFILTERGE Use to find a record whose key field is greater than or equal to the specified values based on a filter.
E@DBFILTERBEGR Use to find the first record in a range based on a filter.
E@DBFILTERSUBR Use to find the first record in a subrange based on a filter.
E@DBFINDMIDRNG Use to find a record within a range you have already established.
E@DBFINDMIDSUB Use to find a record within a subrange you have already established.
E@DBFINDFLTMID Use to find a record within a range you have already established based on a filter.
E@DBFINDFLMDSB Use to find a record within a subrange you have already established based on a filter.
E@DBAGGREGATE Use to work with aggregate ranges. You can use the aggregate range routines whenever you would otherwise use E@DBFINDSUBRNG and E@DBFINDNXTRNG to access a set of rows for the purpose of applying average, maximum, minimum, or sum functions against a column.
E@DBCALCAGGRGT Use to work with aggregate ranges. You can use the aggregate range routines whenever you would otherwise use E@DBFINDSUBRNG and E@DBFINDNXTRNG to access a set of rows for the purpose of applying average, maximum, minimum, or sum functions against a column.

Modify Functions

Function Description
E@DBLOCKEQ Use to read and lock a record in preparation for modifying the record.
E@DBUPDATE Use to read, lock, and then store a record. It combines the actions of an E@DBLOCKEQ and an E@DBSTORE.
E@DBLOCKGE Use to read and lock the record whose key field is greater than or equal to the specified key field in preparation for modifying the record.
E@DBLOCKNXT Use to read and lock the record following the current record in preparation for modifying the record.
E@DBLOCKPRV Use to read and lock the record previous to the current record in preparation for modifying the record.
E@DBLOCKBEGRNG Use to read and lock the first record in a range in preparation for modifying the record.
E@DBLOCKSUBRNG Use to read and lock the first record in a subrange in preparation for modifying the record.
E@DBLOCKNXTRNG Use to read and lock the next record in a range in preparation for modifying the record.
E@DBLOCKMIDRNG Use to read and lock a record within a range you have already established.
E@DBLOCKMIDSUB Use to read and lock a record within a subrange you have already established.

Delete Functions

Function Description
E@DBDELETERNG Use to delete an entire range of records from a file.
E@DBDELSUBRNG Use to delete a subrange of records from a file.
E@DBFULLDELRNG Use to drop all records in a range and their related records according to the delete rules.
E@DBFULLDELSUB Use to drop all records in a subrange and their related records according to the delete rules.