Explain the difference between the tx_commit() command used in the X/Open API and the COMMIT statement in embedded SQL.
What will be an ideal response?
The COMMIT statement in embedded SQL is a local command requesting that the current DBMS be committed. The tx_commit() statement is a request to commit a global transaction, that is to perform a two-phase commit of all the DBMSs that the global transaction has accessed.
Computer Science & Information Technology
You might also like to view...
When displaying a document in Print Preview, the Magnifier can be used enlarge or shrink the size of the previewed page
Indicate whether the statement is true or false
Computer Science & Information Technology
Which shortcut key combination immediately locks Windows?
A. Ctrl+Alt+Del B. Windows+R C. Windows+M D. Windows+L
Computer Science & Information Technology