ROLLBACK Function
Function Type | Predefined function | |
Syntax | ROLLBACK( <table> ) | |
Description | Allows the target database to remove uncommitted records so that a specified group of records can be processed for resubmission if any record within the group fails. | |
Argument | Description | |
<table> | Table to roll back. | |
Returns | Integer | |
Example | This example performs an SQL rollback on the selected table removing any pending updates to that table. Returns "1" if the rollback call was completed. ROLLBACK(Source.Table1) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*