![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• When the first non-duplicate insert succeeds, insert failures for duplicate key conditions are not recognized until a commit is issued or the end of the transaction is reached, and an unrecoverable error is signalled.
• If the table is parameterized, during the mass update other transactions can update table instances that are not being updated. Other transactions cannot update an un-parameterized table during the mass update.
• The IDgen attribute must be set to F. The IDgen attribute must be re-set to N or Y after the mass update to re-invoke the two-phase commit process.The IDgen attribute, which is set as part of a table definition, is used to determine whether TIBCO Object Service Broker should generate values for the primary key field. This field accepts the following values:
The system generates a unique value for the primary key of each occurrence when data is inserted into a table. Users who insert data into the table must enter a unique value for the primary key of each occurrence. If the table definition has been bound, that is, FIX=Y, you cannot dynamically change the IDgen setting unless the table is unbound. Refer to Procedure to Bind or Unbind a Table for more information about binding.
1. From the administrator’s workbench, type the name of the table beside the DT Define Table option and press Enter.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |