15.00 - Command Usage Rules - Teradata Database

Teradata Database Support Utilities

Teradata Database

Command Usage Rules

The following command usage rules apply to Filer commands:

  • A space is required between the following:
  • The cmdoption and the parameterlist
  • The cmd and the parameterlist if you do not specify cmdoption or if the cmdoption is at the end of the command
  • You can combine multiple Filer commands on a single command line, as shown below:
  • Filer is case insensitive, which means that you can enter any command, keyword, or option in uppercase, lowercase, or mixed-case letters.
  • If you end a command line with a backward slash (\), the command line continues on the next line.
  • If an error occurs during processing of a string of commands, processing stops because the latter commands usually depend on the correct processing of commands typed earlier, as shown below:
  • ci /p 0001000600000024;delete /y

    In this case, if there is a problem accessing the CI, you might not want to execute the DELETE command.

  • If an error occurs while parsing the command line, you can type a single question mark (?) as the next command. Filer displays a list of alternatives expected by the parser at that point of the syntax error.
  • If you type another single question mark (?) after Filer displays the alternatives, Filer returns the HELP text for the command in question.

    The following example shows help information about the RADIX command:

    Filer ==>radix in dex 
    radix in de<-Syntax error->x
    Filer ==> ?
    Valid input at the point of error is:
    ;           end of command
    Filer ==> ?
    RADIX [ ( IN[PUT] | OUT[PUT] ) ] [ ( H[EX] | D[EC] )
    Filer ==> ?
    RADIX [ ( IN[PUT] | OUT[PUT] ) ] [ ( H[EX] | D[EC] ) ]
    Sets the Flags for how to treat Unqualified number. Either Hex (base 16) or Decimal (Base 10), respectively. See HELP NUMBER for a description of unqualified INPUT. The initial setting of these Flags
    are HEX.  If neither INPUT nor OUTPUT is specified,
    the command applies to both Flags.  If neither HEX nor DEC is specified, the current setting of the Flag is displayed.
    Filer ==> ?
    No more information available. Use HELP /L
  • Comments are allowed anywhere a blank is allowed. Enclose comments between braces ({}).
  • If Filer does not find a closing brace (}) on the line, Filer interprets the rest of the line as a comment, as shown in the following example:

    Filer ==> db 0 2 1fa { this is the broken data block 
  • If you use a single question mark (?) in place of a legal syntactic element, Filer informs you as to what you can type at that point in the command, as shown below:
  • Filer ==> output ?
    Valid input at the ? is :
     ,           INTO        OVER        TO          ON          ;           
     end of command 

    In this example, Filer accepts any of the following:

  • A comma (,)
  • INTO
  • OVER
  • TO
  • ON
  • A semicolon (;)
  • Other examples of using a single question mark (?) in place of a legal syntactic element are shown below:

    output ?
    output ?{comment}
    output ? {comment
    output {comment} ?
  • Unlike other commands, the PATCH command cannot be combined on the command line with other commands. For more information, see “PATCH” on page 166.