TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

224 Chapter5
TurboIMAGE/XL Library Procedures
DBPUT
Discussion for Master Data Sets
When adding entries to master data sets, the following rules apply:
• The data set must be a manual master.
• The key item must be referenced in the list array and its value in the buffer array must
be unique in relation to other entries in the master.
• Space must be available in the master set, or must be dynamically expandable to add
an entry.
• If dynamic capacity expansion parameters are specified for the master data, when the
master data set is almost full, expansion is done by the incremental amount. If the
expansion is successful, the new record is added to the database. If the expansion is not
successful, an error message is displayed, and the record is not added to the database. If
there is insufficient disc space to expand the data set to the full incremental amount,
DBPUT will perform a partial expansion up to the disc space available. DBPUT will
terminate if there is no available group or account disc space even if there is enough
system disc space. (The current capacity for a data set can be displayed by the SHOW
CAPACITY command in DBUTIL or the output buffer from DBINFO modes 202 and 205.)
• The order of data item values in the new entry is determined by the set definition in the
schema and not by the order of the items' occurrence in the list and buffer arrays.
• Values for data items not included in the list array are filled with binary zeros.
• The caller must have a lock on the data set or the database if the database is open in
access mode 1.
• DBPUT to an indexed master triggers a similar operation to indexed master's B-Tree
index file.
Discussion for Detail Data Sets
When adding entries to detail data sets, the following rules apply:
• The data set must have free space for the entry.
• If the database is opened in access mode 1, the caller must have a lock covering the
entry to be added.
• All search and sort items defined for the entry must be referenced in the list array.
• Each related manual master data set must contain a matching entry for the
corresponding search item value. If any automatic master does not have a matching
Commercial
At-Sign
@; or @
Request procedure to use all data items
of the data set in the order of their
occurrence in the entry.
NOTE: indicates blank
Table 5-20. Special list Parameter Constructs
Construct list Array Contents Purpose