HP MPE/iX 6.x Operating System manual 177

FORM, which displays a database structure

LIST, which displays data in a data set

FIND, which searches a data set for data items

REPORT , which displays data in a data set located b y the FIND command in the format y ou specify

XEQ, which executes QUERY/V commands stored in a text ￿le

EXIT, which terminates QUERY/V execution

Table 7-3 shows a comparison of data managemen t considerations to help y ou determine whether to set up a data base with T urboIMAGE/XL or KSAM.

The preferred choice of KSAM over TurboIMAGE/XL for generic k ey retrieval is based on the fact that KSAM automatically handles partial k ey searches. A TurboIMAGE/XL database requires de￿ning an additional master set and detail set to handle the partial k ey search, as well as requiring some additional programming.

Table 7-3. Data Management Considerations

	TurboIMAGE/XL	KSAM
Heavy sequential	no	yes
processing
Unanticipated inquiries	yes	use FCOPY
Program-data	yes	no
independence
Easy conversion from	no	yes
ISAM
Privacy and security	yes	￿le level only
Privileged ￿les	yes	no
(protected)
Variable-length records	no	yes
Field access by name	yes	no
Generic (partial) key	no	yes
retrieval
Sorted retrieval by key	yes	yes

Data Management 7-19