Wednesday, December 09, 2015

SQLMP Programming TIP

In the SQLMP programming, dont use the SQL Statements like

 - BEGIN WORK
 - COMMIT WORK
 - ROLLBACK WORK

Instead , pls use the equalent TAL statements
      START TRANSACTION
      ABORT TRANSACTION and
      END TRANSACTION.

The reason is, SQL Statements like COMMIT WORK , also performs FREE RESOURCES which will results in closing cursors.

No comments: