Usage Notes - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
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.