DtpConnection class

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().

Important:
The DtpConnection class and its methods are supported for backward compatibility only. These deprecated methods will not generate errors, but you should avoid using them and migrate existing code to the new methods. The deprecated methods might be removed in a future release. In new map development, use the CwDBConnection class and its methods to establish a database connection.

Table 98 summarizes the methods in the DtpConnection class.

Table 98.

DtpConnection method summary
Method 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()

Copyright IBM Corp. 2003