You can translate the question and the replies:

JDBC Scheduler Exporter: Delete table content:: Truncate or delete?

In the exporter section (JDBC) of a scheduler job, there is an option to "Delete table content:". Does this use truncate or delete? I need to know what grants to set int he database (Oracle 19c).
Exporter section
user
02-09-2021 14:11:37 -0400
code

1 Answer

Hi, The "Delete table content" (the content of the table is always deleted at the beginning of the job execution, not at the beginning of the exportation phase) option available in the JDBC exportation section of Scheduler Administration tool will use delete or truncate commands based on the "Error Management" scenario that you have configured. 1) "Never rollback" - the content of the table will be deleted using the "Truncate" statement as it will not allow rollback of data. 2) "Rollback if the exportation of all documents fails/ Rollback if any exportation error occurs"- the content of the table will be deleted using the "Delete" statement which will allow rollback in case of any errors. Hope this helps!
Denodo Team
02-09-2021 19:19:59 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here