Closes all open cursors that were not opened using the WITH HOLD clause, even if the application has not appropriately closed
them.
Syntax:
>>---EXEC SQL---SYNCPOINT---END-EXEC---><
Comments:
Use SYNCPOINT in the XA switch modules provided for Enterprise Server environments to ensure that all cursors that were not
opened using the WITH HOLD clause have been closed before a new unit of work is started.
In Enterprise Server environments, SYNCPOINT ensures that all database locks acquired are released if the application fails
to close cursors explicitly.
Comments:
Use SYNCPOINT in the XA switch modules provided for Enterprise Server environments to ensure that all cursors that were not opened using the WITH HOLD clause have been closed before a new unit of work is started.
In Enterprise Server environments, SYNCPOINT ensures that all database locks acquired are released if the application fails to close cursors explicitly.