CHECK AGAIN Command Restrictions - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Each CHECK command generates an error file containing a list of the significant errors. Use the CHECK AGAIN command to check only the (failed) tables listed in an error file. You can also specify an input error file or let CheckTable default the input error file to the output error file generated by the previous CHECK command.

If Error-filename is not specified, the last error file generated by the previous CHECK command in the current CheckTable instance is used as input.

Error-filename may be a fully qualified filename (such as /var/tmp/CheckTableErrors20130503164640) or a relative path filename (for example, CheckTableErrors20130503164640).

For a relative path name, the root directory is the error file directory, which is managed with the ERRORFILEDIR command.