HP 3000 Manuals HP 3000 Manuals
Tune Access Screen Use this screen to specify how data is to be retrieved from the source tables.To define how the data is to be retrieved 1. Type the Access Sequence, Key, Lock Mode (Open Mode and Item Level Security for IMAGE data sets) for each source table. 2. Press Enter. Banner Line Shows for which table you are tuning access. Field Descriptions Source Table Display. All source tables defined for this table. Table Type Display. The table type for each source table (IMAGE, SQL, KSAM, MPE, BRW, IRF = Intermediate Report File). Access Sequence The order in which the source tables are to be accessed. Note that the source table on which an open join is made must be accessed last. SQL tables belonging to the same DBEnvironment can be combined into one query by specifying the same access sequence number for each table. This is the default if the tables are listed consecutively on the Define Table screen and no open join is specified. If different numbers are specified for HP ALLBASE/SQL tables in the access sequence number field, then separate queries will be generated. Key Optional. The name of the key from the following table, if the report requires keyed access. If this field is left blank, files are read serially. There is no keyed access to HP ALLBASE/SQL tables. ---------------------------------------------------------------------------------------------- | | | | | Source Table Type | Key | Result | | | | | ---------------------------------------------------------------------------------------------- | | | | | IMAGE detail | search item | chained read | | | | | | IMAGE master | search item | calculated read | | | | | | KSAM file | key element | read by value | | | | | | Anything but HP ALLBASE/SQL | TABLE-REC-NUMBER | directed read | | | | | ---------------------------------------------------------------------------------------------- Items defined as relations can be used as keys. If a key is made up of several items, all of them must be defined as relations on the Define Relation screen.
NOTE If TABLE-REC-NUMBER is to be used as a key to a source table, a relation must also be defined with TABLE-REC-NUMBER for that source table and an other item which provides the record number. If keyed access is used for the first source table in the access sequence, a relation must be defined in which a single-value or list-of-values parameter provides the values for that key.
Lock Mode Optional. The type of lock desired. Use the following two tables: Locks on IMAGE data sets, or files R Retry N number of times every T seconds, where N and T are configuration variables. See Chapter 17 for details about configuration variables. A Try once, then stop. W Wait until lock is granted. Caution: This may cause deadlocks if more than one lock is specified with keyed access! Locks on an HP ALLBASE/SQL table S Allow other users to read but not change the table. A lock on an HP ALLBASE/SQL table is always unconditional, that is, HP ALLBASE/BRW will wait until the lock has been acquired. Open Mode Optional. (IMAGE only) The mode to be used by HP ALLBASE/BRW when opening an HP IMAGE/3000 database. HP ALLBASE/BRW will use DBOPEN with this mode when opening the database. The possible DBOPEN modes are: Access Mode Capabilities 5 Read, allow concurrent modify 6 Read, allow concurrent modify 7 Read, exclusive 8 Read, allow concurrent read Consult the HP IMAGE/3000 Data Base Management Reference Manual for a full description of the DBOPEN modes and capabilities. (The default DBOPEN mode is 5, unless it has been altered on the Execution Values screen when configuring HP ALLBASE/BRW. See Chapter 17 .) It is not possible to have two different database open modes for data sets that are in the same data base, and on the same Define Tables screen, and that have the same password.
NOTE HP ALLBASE/BRW opens an HP ALLBASE/SQL DBEnvironment with the CONNECT command. The DBEnvironment parameters "Autostart Mode" and "User Mode" must be set by the DB Administrator to ON and MULTI, respectively.
Item Level Security Optional. (IMAGE only) By default, HP ALLBASE/BRW reads all items in an IMAGE data set, and the password on the Define Table screen for that data set must give access to all items in the data set. If your data set has security at item level, type an X in this field and HP ALLBASE/BRW will only try to read the items needed for that report, and not all the items in the data set. In this case the password on the Define Tables screen need give access only to those items needed in the report.
![[]](../../pic3k/M011795/FFN2143c50.gif)