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.