Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix B SSOLite Stored Procedures : Control Procedures : SW_INIT_TABLES

SW_INIT_TABLES
The SW_INIT_TABLES procedure creates the temporary tables needed to store data for the current database session.
Syntax
SW_INIT_TABLES ()
Notes
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.
Example

 
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
Copyright © TIBCO Software Inc. All Rights Reserved