On commit preserve rows defines declarative global temporary tables

On commit preserve rows define declarative global temporary tables each session has its own unique temporary table description. When the session ends, both the table row and the description of the temporary table are deleted. The following options are available to control the status of the temporary table after the commit operation: on commit delete rows: When the COMMIT operation is executed, if the with hold cursor is not enabled ON the table, all ROWS in the table will be deleted. This is the default setting. On commit preserve rows: All ROWS in the table are retained when the COMMIT operation is executed. On rollback delete rows: When performing the ROLLBACK (or ROLLBACK to SAVEPOINT) operation, if the table data has been modified, all ROWS in the table are deleted. This is the default setting. On rollback preserve rows: When performing the ROLLBACK (or ROLLBACK to SAVEPOINT) operation, all ROWS in the table are retained. Delete rows is used for transaction correlation, and truncate data in the temporary table after the transaction ends. preserve rows indicates that the data in the temporary table is cleared after the session ends. The former is cleared after the transaction is committed. the latter data will be cleared when the session is terminated or when the wizard exits.