Usage Notes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

FILLER Command Usage Notes 
Topic Usage Notes
Intermixing Commands One or more FILLER commands can be intermixed with TABLE and FIELD commands.

All of these commands must follow a LAYOUT command.

Specifying Graphic Data Types The following lists the input length and field description for the graphic data type specifications that can be made in the datadesc parameter:

GRAPHIC(n)

  • Length: n*2 bytes, if n is specified; otherwise 2 bytes, as n=1 is assumed.
  • Description: n double-byte characters (1n is the length of the input stream in terms of double-byte characters).

LONG VARGRAPHIC

  • Length: m + 2 bytes where m/2 <= 16000.
  • Description: 2-byte integer followed by m/2 double-byte characters.
LONG VARGRAPHIC also implies VARGRAPHIC (16000). Range is 0 to 16000 in a 32,000-byte field.
startpos Specification The specified starting position:
  • Reflects removal of any columns per the CONTINUEIF clause of a LAYOUT command
  • Ignores any indicator bytes per the INDICATORS specification of a LAYOUT command
  • Is relative to character position 1

Therefore, the first data position of the input record is position 1.

For more information about the CONTINUEIF and INDICATORS specifications, see the LAYOUT command description.