Define the Call

When you create a database call, the first thing you need to do is define the call as a query, join, union, or subselect clause, which further defines qualify a query, join, or union call but is defined as a separate call. You can also define a Path call to access parent and child records.

Query

• A non-loop query can Obtain, Modify, Erase, and/or Store information
• A loop query can Obtain and Loop on information

Join

These can Obtain and Loop on information. You can also specify a correlation name prefix for each table.

Union

These can Obtain and Loop on information. First, define the first Select clause for the first table. You define the subsequent Select clause(s) after you fully define the first one.

Subselect

When you define a Subselect call, you choose the action based on the type of call you are further defining.

Path

To define this type of call, you first specify Position only, or specify Position and Loop. Then, for child records, select one or more: Obtain, Modify, Erase, Store. For example, to position on the parent record and loop on its child, specify the Position and Loop actions for parent record, and the Obtain action for the child. You can also specify the Modify, Erase, and Store actions for the child record if you want the user to be able to perform those actions against it.