XTRNTYPE.ddl: Transaction Types Definition
Part of DB2 Transaction Types: Defines the structure and types for transaction data within the DB2 Transaction Types module.
Files
- DB2CREAT.ctlThis program defines transaction types by creating a unique index on the TR_TYPE column of the TRANSACTION_TYPE table. The index ensures that each transaction type is distinct and improves query performance for transaction type lookups.View
- DB2CREAT.ctlThis DDL statement defines a unique index named XTRAN_TYPE on the TR_TYPE column of the TRANSACTION_TYPE table. This index is created as part of the Transaction Types Definition program. The index is configured with ERASE NO and CLOSE NO options, indicating that data erasure is not immediately performed and the index is not closed after creation, respectively.View
- XTRNTYPE.ddlRelated flowView