Previous Topic Next topic Print topic


Record Selection

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.

Previous Topic Next topic Print topic