Download Delete Subset tab

The Download Delete Subset tab applies if the download delete subset is set to Same or Custom. The Download Delete Subset tab shows the following information for the selected table mapping:

  • Tables to add to the download delete cursor's FROM clause   Type the table name(s) if your download_delete_cursor requires a join to other tables. If the join requires multiple tables, separate them with commas. If the download delete subset is set to Same, this shows the download subset tables and is not editable.

  • SQL expression to use in the download delete cursor's WHERE clause   Type a SQL expression to be added to the generated download delete cursor WHERE clause. You do not have to write a complete download_delete_cursor. You only need to add extra information to identify the join and other restrictions on the download delete subset. If the download delete subset is set to Same, this shows the download subset SQL expression and is not editable.

  • Delete shadow table columns   This is displayed if you are using a shadow table to track deletes. Choose any extra columns needed by the SQL expression that should be placed in the delete shadow table.

 See also