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.
- 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:
Post a Comment