The DtpConnection class is part of the Data Transformation Package (DTP). It provides methods for executing SQL queries on the relationship database. To instantiate this class, you must call getRelConnection() in the BaseDLM class. All maps are derived or subclassed from BaseDLM so they have access to getRelConnection().
Table 98 summarizes the methods in the DtpConnection class.
DtpConnection method summaryMethod | Description | Page |
---|---|---|
beginTran() | Begins an SQL transaction for the relationship database. | beginTran() |
commit() | Commits the current transaction in the relationship database. | commit() |
executeSQL() | Executes a SQL query in the relationship database by specifying a CALL statement. | executeSQL() |
execStoredProcedure() | Executes an SQL stored procedure in the relationship database by specifying its name and parameter array. | execStoredProcedure() |
getUpdateCount() | Returns the number of rows affected by the last write operation to the relationship database. | getUpdateCount() |
hasMoreRows() | Determines whether the query result has more rows to process. | hasMoreRows() |
inTransaction() | Determines whether a transaction is in progress in the relationship database. | inTransaction() |
nextRow() | Retrieves the next row in the query result vector. | nextRow() |
rollBack() | Rolls back the current transaction in the relationship database. | rollBack() |