Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the ACCEPT command.

ACCEPT Command Considerations 
Topic Usage Notes
Coding Multiple Variables When multiple variables are coded, each is sequentially assigned input text up to the first space character encountered that is not within a quoted string.
Delimiting Input Text Input text for numeric values must be delimited only by space characters or record boundaries.

Character strings must be enclosed in apostrophes. For example, the data record provided to satisfy the following ACCEPT command includes two fields:

.Accept age, name from file info;

The following example shows two sample data records, where the first is correct but the second is not:

32  'Tom'
32   Tom
Number of Variables When the number of variables listed is greater than the number of responses available, unused variables remain undefined (null). If there are not enough variables to hold all responses, Teradata MultiLoad issues a warning message.
Source File Record Restriction A single record, row, or input line is accepted from the designated source. Always make sure that there is only one record in the file from which the ACCEPT command is getting the variables.
Specifying the System Console/Standard Input Device Use the asterisk (*) character as the fileid specification for the system console/standard input (stdin) device.

The system console is the:

  • Keyboard in interactive mode
  • Standard input device in batch mode

For more information about the keyboard and standard input devices, see File Requirements.

z/OS fileid Usage Rules If a DDNAME is specified, Teradata MultiLoad reads data records from the specified source.

A DDNAME must obey the same construction rules as Teradata SQL column names except that:

  • The “at” character (@) is allowed as an alphabetic character.
  • The underscore character (_) is not allowed.

The DDNAME must obey the applicable rules of the external system and may reference a sequential or VSAM data set.

If the DDNAME represents a data source on magnetic tape as supported by the operating system, the tape may be either labeled or non-labeled.