Processing Procedure

Type

Concept

Purpose

A DQL Processing procedure can enter, delete, and modify records, as well as create screen, disk, or printed output based on the script instructions, the data stored in database tables, and additional data input during the execution of the procedure.

Usage

The Processing commands (shown at right) are primarily used to create a Processing procedure. These commands can also be used in a Control procedure.

Example

for MEMBERS ;

list records

LAST NAME in order ;

TOTAL DUE .

end

This script tells DataEase: (1) Process all the MEMBERS records, and (2) for each record processed, list the LAST NAME and the TOTAL DUE values and arrange the output in alphabetical order by LAST NAME.

Note: When accessing data in an SQL database, DataEase treats a Processing procedure as a single transaction, unless you use the DQL begin transaction and commit commands to divide the procedure into multiple transactions.