Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
Important: The Record Selection dialog box is dynamic. The fields and controls that appear on it depend on the database call you are
defining. The following list represents all possible fields or controls you might encounter:
- Database Type
- This dialog box shows the attributes for all of the screen fields.
- Query Type
- Specify whether the call is a:
- Query
- Default for all targets. For
SQL, select
Query to define a call that consists of one Select clause. To define an SQL Join call, select
Query and define multiple query calls.
- Subselect
- For
SQL only. Select this to define a Subselect clause. You define a Subselect separately from a Query, Union, or Join call, and
then include the Subselect in your call when you qualify it.
- Union
- For
SQL only. Select to define a Union call.
- Record
- Lists the records available in the program for which you can define database calls. Click a record to define a database call
for it.
- Obtain
- Check this to Obtain information for the corresponding record.
- Loop
- Check this to Loop on information for the corresponding record.
- Modify
- Check this to Modify information in the corresponding record.
- Erase
- Check this to Erase information in the corresponding record.
- Store
- Check this to Store information in the corresponding record.
- Alias
- Type a short-hand name (alias) for the table.
- Position
- Check this to ???
- Self-Join
- Check this to create a self join for the database call.
- Isolation Level
- Select an isolation level, which determines how data is locked and isolated from other processes while the data is being accessed,
from the following:
| CS
|
with cursor stability
|
| RS
|
with read stability
|
| RR
|
with repeatable read capability
|
| UR
|
with an uncommitted read capability
|
This field is optional.