The Re-create window, as shown in the following screen provides available options for dropping and recreating an existing table and associated procedures. Objects and actions available depend on the table being recreated.
Actions in the table are completed from top to bottom; the action performed on each object can be set as desired:
Object(s) | Action | Description |
|---|---|---|
Load Tables | Do Nothing (Default) | Do nothing for this object, skip to the next action. |
Load | Perform an interactive load of the data into the table. WhereScape recommends performing this via the Scheduler for large tables. | |
Load via Scheduler | Add a data load task to the scheduler. Useful for large tables where processing may take some time. | |
Load Script | Regenerate | Regenerate the table's load script. This option is only available for Load tables with a load type of script and with the source connection setting defined. If the Load table does not have an existing script then a new script is created. |
Update procedure | Do Nothing (Default) | Do nothing for this object, skip to the next action. |
Execute | Execute the update procedure. WhereScape recommends performing this via the Scheduler for large tables. | |
Execute via Scheduler | Execute the update procedure via the scheduler. Useful for large tables where processing may take some time. | |
Tables | Do Nothing | Do not display the data. |
Display Data | Display the table data after recreating the table and updating the procedure (if applicable).
|
Save these choices as the Defaults
This option can be used to store the current actions as the default choices for all object types. The Re-create window is then automatically populated with the saved actions each time it appears.
Count the Rows in the Table
Displays the total number of rows in the table at the bottom of the Re-create window. Knowing the number of rows in a table can help estimate how long Load and Execute actions may take.