![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Take the following effects into consideration when selecting DB2 columns for a TIBCO Object Service Broker DB2 table definition:
• Only the DB2 columns you select in your TIBCO Object Service Broker DB2 table definition are requested from DB2. Consequently, if these columns reside in the DB2 index, DB2 could return results without having to read its data pages.
• If you need to insert rows to DB2 tables, ensure your DB2 table definition includes all NOT NULL (without default) fields.
• If you choose DB2 columns as parameters that correspond to a unique key of a DB2 table, you can insert only a single row using this definition. This is because the Gateway combines the parameter values with the TIBCO Object Service Broker primary key values, causing an attempt to insert a duplicate row to DB2.
• The maximum occurrence length of the defined expanded fields must be less than or equal to 31744 bytes.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |