- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] Can commit be carried out only for the records without error in [Execute Update SQL Process]?
Search via FAQ No.
[DataSpider Servista] Can commit be carried out only for the records without error in [Execute Update SQL Process]?
In [Execute Update SQL Process], is it possible to commit only the records without error by rolling back the records with errors?
- Category :
Answer
It is possible to combine [Loop by Number of Data] icon and [Monitor Exception] with [Execute Update SQL Process] icon.
While processing [Monitor Exception], it will be the process that commits only the correct records by passing the input data one by one from [Loop by Number of Data] to [Execute Update SQL process].
If you use Log Output icon or CSV Write process, then the record with error will be displayed during error occurrence and hence it is possible to check the error occurred data after execution.
The sample of this case is published in "Sample Script" of that site. Refer to the Reference Information for details.・Sample script
https://www.hulft.com/help/ja-jp/DataSpider/latest/help/ja/reference/scenario/rl_reference_047.html
*Contents of the following link might be in Japanese.
*Contents of the following link might be in Japanese.
・Loop by Number of Data