![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• The sum of the external field lengths must be less than or equal to the VSAM data set record length.
• Composite key fields must be contiguous but do not have to start at the beginning of the record.
• To access a VSAM file by an alternate index, define the alternate index as the primary key in the TIBCO Object Service Broker table and specify the alternate index path as the data set name.
• To update a VSAM file via its alternate index, it must be defined through IDCAMS using the UPGRADE option.
• Updates to rows with duplicate secondary indexes must be done using a definition that has the primary key set to the VSAM primary key.
• The architecture of KSDS type files specifies that the initial record can only be added by a sequential write operation. There are two ways to handle the initialization of a VSAM KSDS file:
− The IDCAMS utility can populate the data set using the REPRO statement. This can be done in the same job that initializes the VSAM KSDS data set.
− Using TIBCO Object Service Broker, ensure the Load option on the Table Definer is set to Y.At least one record must then be inserted into the table. When a record is inserted, the Load option can be set to N, if desired.
• The sum of the field lengths, excluding the primary key, must be less than or equal to the VSAM data set record length.
• The primary key field must be a 4-byte binary. This field represents a relative byte address (RBA). It specifies the relative offset in the data set of the record being accessed. The first record has an RBA of 0.
• Access by alternate index can be accomplished by defining the secondary index as the primary key in TIBCO Object Service Broker and using the secondary index path as the data set name.
• The sum of the field lengths, excluding the primary key, must be less than or equal to the VSAM data set record length.
• The primary key field must be a 4-byte binary. This field represents a record number that identifies each record in the data set. The first record has a record number of at least 1.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |