Follow-On Topics

Related Topics

# About the Options Tab

The Options tab of the OLEDB Memory dialog box is used to configure the memory behaviour if an error occurs when the Step is being processed. The following options are provided for selection:
|  | Do not write — No data is memorised.
|  | Write for each row processed — Data is memorised for each row processed.
|  | Write for each row processed based on a rule — Data is memorised for each row based on a rule. A field below the option displays the selected rule. Clicking on the Edit button opens a Rule Script dialog box to create a new rule or edit an existing one.
| Click the image to view full size.

|  | Use Transactions — If selected then the database operations are processed using transactions.

The following options are available for memory update:

|  | Update on Success — Copies rows that were successfully processed, based on the memory options selected, into the selected database table.

|  | Update on Failure — Copies rows that failed to be processed, based on the memory options selected, into the selected database table.

|  | Update based on a rule — Copies rows based on a rule into the selected database table. A field below the option displays the selected rule. Clicking on the Edit button opens a Rule Script dialog box to create a new rule or edit an existing one.

|  | If an error occurs — This area contains the following options:

|  | Abort Step — If an error occurs then the Step is aborted.

|  | Continue Step — If an error occurs then the Step will continue.

Copyright © 2018 Quadrant Software B.V. All rights reserved.