HiRDB Dataextractor Version 8 Description, User's Guide and Operator's Guide

[Contents][Index][Back][Next]

4.1.1 Conventions for extraction

This section describes HiRDB Dataextractor's data extraction conventions.

Organization of this subsection
(1) Lock

(1) Lock

HiRDB Dataextractor enables you to lock a table during data extraction. The xtrep command's -g option is used to specify whether or not locking is to be used. By locking the table, you can reduce lock processing time. Table 4-1 shows the relationship between specification of the -g option and the lock mode. For details about the lock modes, see the HiRDB UAP Development Guide.

Table 4-1 Relationship between -g option specification and lock mode

-g option specification Resources
RDAREA Table Row Key value
For table For index
Specified (do not lock by issuing LOCK statement) SR SR SR PR PR
Omitted (lock by issuing LOCK statement) SR N PR N N

SR: Shared retrieval mode

PR: Protected retrieval mode

N: Do not lock