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