Subject not found.
1.

Explain How The Auto Commit Property Works In Pb?

Answer»

When the Auto Commit property is set to FALSE (default) or 0, PB issues SQL statements inside the scope of a transaction. 1(TRUE) implies statements outside the scope of a transaction (for example when your application requires creating TEMPORARY TABLES).

  • If you want to execute STORED procedures containing DDL (CREATE, ALTER, DROP etc) statements, then Auto Commit = TRUE.
  • If Auto Commit = TRUE, then rollback cannot be issued, it should be set to FALSE after completing the DDL operation.

When Auto Commit is set from FALSE to TRUE, then PB issues a COMMIT STATEMENT by default.

When the Auto Commit property is set to FALSE (default) or 0, PB issues SQL statements inside the scope of a transaction. 1(TRUE) implies statements outside the scope of a transaction (for example when your application requires creating temporary tables).

When Auto Commit is set from FALSE to TRUE, then PB issues a COMMIT statement by default.


Discussion

No Comment Found

Related InterviewSolutions