Application Techniques
Data Access Techniques

Table of Contents

About Transaction objects

Description of Transaction object properties

Transaction object properties and supported PowerBuilder database interfaces

Working with Transaction objects

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

Using Transaction objects to call stored procedures

Step 1: define the standard class user object

Step 2: declare the stored procedure as an external function

Step 3: save the user object

Step 4: specify the default global variable type for SQLCA

Step 5: code your application to use the user object

Supported DBMS features when calling stored procedures