void executeSQL(String query) void executeSQL(String query, Vector queryParameters)
None.
DtpConnectionException - If a database error occurs.
Before executing a query with executeSQL(), you must create a DtpConnection object with the getRelConnection() method from the BaseDLM class.
The SQL statements you can execute include INSERT, SELECT, DELETE, and UPDATE. You can also execute stored procedures with the limitation that this stored procedure cannot use any OUT parameters. To execute stored procedures with OUT parameters, use the execStoredProcedure() method.
The following example executes a query for inserting rows into a table in the SapCust relationship.
DtpConnection connection = getRelConnection("SapCust"); // begin a transaction connection.beginTran(); // insert a row connection.executeSQL("insert..."); // commit the transaction connection.commit(); // release the database connection releaseRelConnection(true);