Working with
Transaction objects
Contents
- Transaction basics
- The default Transaction object
- Assigning values to the Transaction object
- Reading
values from an external file - Connecting to the database
- Using the Preview tab to connect in a PowerBuilder
application - Disconnecting from the database
- Defining Transaction objects for multiple database
connections - Error
handling after a SQL statement - Pooling database
transactions
PowerBuilder uses a basic concept of database transaction processing
called logical unit of work (LUW). LUW is synonymous with transaction. A
transaction is a set of one or more SQL statements that forms an LUW.
Within a transaction, all SQL statements must succeed or fail as one
logical entity.
There are four PowerScript transaction management statements:
-
COMMIT
-
CONNECT
-
DISCONNECT
-
ROLLBACK
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest