- TP_ROLLBACK

In order for TP_ROLLBACK to function properly, two Environment Variables must be set. The CISAMLOG must equal the logfile path; and the TP_ROLLBACK flag must equal Y. For example, use the following to set the Environment Variables.

CISAMLOG=<your logfile path>
TP_ROLLBACK=Y

The following rules apply to TP_ROLLBACK:

If there are not SQL files, the function behave as in Version 1.5 (errors are not fatal and processing continues.)
If there are SQL files, the Version 2.2 rollback behaviour is used (@RFUNCT is called). This applies even if some of the files are PROISAM.
The behaviour in case 1 is replaced by case 2, if TP_ROLLBACK is enabled. This can also be used for other non-SQL filing systems that support transaction processing.

Comment on this topic

Topic ID: 720255