4 Database Manipulation
Introduction
This chapter introduces the Eloquence DBMS manipulation statements. A functional description of each statement is provided as well. Since a working knowledge of the Eloquence language is assumed throughout this chapter, refer to the Eloquence Manual when necessary.
The following list summarizes the manipulation statements. For example programs using these statements, refer to page 141 . The syntax conventions used in this chapter are the same as those described in page 11 .
- DBLOGON
- Provides authorization information used when contacting the database server.
- DBOPEN
- Initiates access to a database. Sets up the access mode and user-class number for the specified database.
- DBCLOSE
- Terminates access to a database.
- DBGET
- Reads the data items of a specified entry in a data set.
- DBUPDATE
- Modifies specified item values in an entry. (Search items cannot be modified.)
- DBPUT
- Adds new entries to a data set.
- DBDELETE
- Deletes existing entries from a data set.
- DBFIND
- Locates the first and last entries of a data chain in a detail data set in preparation for access to that chain.
- DBINFO
- Provides structural database information such as data item names, data set names, and field descriptions.
- DBBEGIN
- Initiates a transaction.
- DBCOMMIT
- This statement finishes a transaction.
- DBROLLBACK
- This statement interrupts a transaction and all database modifications since the DBBEGIN of this transactionent.
- DBLOCK
- Locks database records to allow the user exclusive access.
- DBUNLOCK
- Unlocks database records locked with previous DBLOCKs.
- DBASE IS
- Defines the database to be used prior to the IN DATA SET statement.
- IN DATA SET
- Automatically packs the buffer parameter during DBPUT and DBUPDATE. Automatically unpacks the buffer after DBGET.
- PREDICATE
- Defines the database records to be locked via DBLOCK.
Eloquence Database Manual - 19 DEC 2002