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 50. 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. 2003, 2004