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 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.