Database connection function blocks

The function blocks in the General\APIs\Database Connection folder provide basic functionality for managing database connections and executing SQL queries in the database. The following sections detail each function block.

Table 71. Summary of database connection function blocks
Function block Page
Begin Transaction Begin Transaction
Commit Commit
Execute Prepared SQL Execute Prepared SQL
Execute Prepared SQL with Parameter Execute Prepared SQL with Parameter
Execute SQL Execute SQL
Execute SQL with Parameter Execute SQL with Parameter
Execute Stored Procedure Execute Stored Procedure
Get Database Connection Get Database Connection
Get Database Connection with Transaction Get Database Connection with Transaction
Get Next Row Get Next Row
Get Update Count Get Update Count
Has More Rows Has More Rows
In Transaction In Transaction
Is Active Is Active
Release Release
Roll Back Roll Back

Copyright IBM Corp. 2004, 2005