Retry a Failed SQL Statement - System Emulation Tool

Retry a Failed SQL Statement

When importing object definitions, errors can occur (such as insufficient privileges or permanent space). Use the SQL Statement Failed dialog box to retry the failed statement.

Note: This dialog box is available if the Display Failed SQL statement dialog option is selected in the Options dialog box, regardless of whether the Ignore Teradata Database errors check box is selected. The dialog box appears when there is an error. See “Error‑Handling Options” on page 55.

To retry a failed statement

1 When the SQL Statement Failed dialog box appears, do one of the following:

Click Abort to automatically abort the import operation.

Enter another SQL statement:

i Type a statement to grant the necessary privileges or increase the permanent space.

i Type a statement to grant the necessary privileges or increase the permanent space.

ii Click Retry.

Click Retry to retry the failed statement if the error has been corrected by other means.

Click Ignore to ignore the error and proceed with the import of the remaining objects.

2 Click Hide Failed SQL to hide the Failed Statement pane.