INPUT - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

The INPUT command informs Ferret to read commands from a file you specify rather than from the default input file STDIN.

Syntax

{ INPUT | IN } FROM file
file
The name of a file you specify as the source of command input to Ferret.

Usage Notes

When you first start Ferret, it accepts input from the STDIN file by default. Using the INPUT command, you can redirect input from any file you specify.

The input file must be located on the node that runs the control AMP. To determine which node is running the control AMP, use the STATUS command of the Vproc Manager utility. The control AMP is designated under the Logical Configuration with an asterisk.

When Ferret reaches the end of the file you specify, Ferret again accepts input from you, if the file does not instruct Ferret to quit.

You can nest the INPUT command inside command files to a maximum of nine files deep.

Example: Directing Ferret to read input commands from a file

The following command example shows the format for redirecting input from a file in a specific directory:

Ferret ==>
Input from /home/user1/commands