CLEAR - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose  

The CLEAR command cancels the definitions that were specified by a previous DEFINE command, including the input data source.

Syntax  

Usage Notes

The CLEAR command is:

  • Local to Teradata FastLoad
  • Not transmitted to the Teradata Database
  • Intended for online use
  • Example

    The following command example cancels the field definitions and input data source or INMOD name of a previous DEFINE command:

    CLEAR ; 
    Completion Message

    The Teradata FastLoad completion message is:

    Warning: All previous column and file definitions cleared!

    If the SHOW command now is entered, the result is blank.