![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The SW_INIT_TABLES procedure creates the temporary tables needed to store data for the current database session.The SW_INIT_TABLES procedure can be useful when a single database transaction is expected to run for a considerable period of time, because creating temporary tables during a transaction can block other SSOLite transactions.You need only call SW_INIT_TABLES once per database session, although multiple calls will not affect performance.
EXEC owner.SW_INIT_TABLES -- Called outside of the transaction
-- to avoid unnecessary database
-- blocking.
begin transaction -- Start the tansaction.
EXEC swpro.SW_CASESTART ... -- Multiple SSOLite procedure calls.
EXEC ...
EXEC ...
.
.
commit -- Commit the transaction
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |