cancel a transaction that was earlier prepared for two-phase commit NAME ROLLBACK_PREPARED - cancel a transaction that was earlier prepared for two-phase commit SYNOPSIS ROLLBACK P…...is not standardized. SEE ALSO COMMIT PREPARED ( COMMIT_PREPARED (7)), ROLLBACK PREPARED ( ROLLBACK_PREPARED (7))...tandardized. SEE ALSO PREPARE TRANSACTION ( PREPARE_TRANSACTION (7)), ROLLBACK PREPARED ( ROLLBACK_PREPARED (7))abort the current transaction NAME ROLLBACK - abort the current transaction SYNOPSIS ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION ROLLBACK rolls back the curren…define a new savepoint within the current transaction NAME SAVEPOINT - define a new savepoint within the current transaction SYNOPSIS SAVEPOINT savepoint_name DESCRIPTION SAVEPOINT…roll back to a savepoint NAME ROLLBACK_TO_SAVEPOINT - roll back to a savepoint SYNOPSIS ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name DESCRIPTION Roll back all co…release a previously defined savepoint NAME RELEASE_SAVEPOINT - release a previously defined savepoint SYNOPSIS RELEASE [ SAVEPOINT ] savepoint_name DESCRIPTION RELEASE SAVEPOINT r…abort the current transaction NAME ABORT - abort the current transaction SYNOPSIS ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION ABORT rolls back the current transac…start a transaction block NAME BEGIN - start a transaction block SYNOPSIS BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEVE…commit the current transaction NAME END - commit the current transaction SYNOPSIS END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION END commits the current transaction. A…commit the current transaction NAME COMMIT - commit the current transaction SYNOPSIS COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION COMMIT commits the current trans…close a cursor NAME CLOSE - close a cursor SYNOPSIS CLOSE { name | ALL } DESCRIPTION CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subseq…define a cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…execute a prepared statement NAME EXECUTE - execute a prepared statement SYNOPSIS EXECUTE name [ ( parameter [, ...] ) ] DESCRIPTION EXECUTE is used to execute a previously prepare…prepare a statement for execution NAME PREPARE - prepare a statement for execution SYNOPSIS PREPARE name [ ( data_type [, ...] ) ] AS statement DESCRIPTION PREPARE creates a prepar…deallocate a prepared statement NAME DEALLOCATE - deallocate a prepared statement SYNOPSIS DEALLOCATE [ PREPARE ] { name | ALL } DESCRIPTION DEALLOCATE is used to deallocate a prev…start a transaction block NAME START_TRANSACTION - start a transaction block SYNOPSIS START TRANSACTION [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEV…restore the value of a run-time parameter to the default value NAME RESET - restore the value of a run-time parameter to the default value SYNOPSIS RESET configuration_parameter RE…lock a table NAME LOCK - lock a table SYNOPSIS LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW E…show the execution plan of a statement NAME EXPLAIN - show the execution plan of a statement SYNOPSIS EXPLAIN [ ( option [, ...] ) ] statement where option can be one of: ANALYZE […