Difference between text format and unformat in mload

Tools
Enthusiast

Difference between text format and unformat in mload

Hi,

I want to know the difference in mload script for text and unformat type of format.
And what is the sructure of data source in both case.

Thanks.
1 REPLY
Teradata Employee

Re: Difference between text format and unformat in mload

TEXT data format consists of 'n' bytes of data, followed by an end-of-record marker (usually 0x0a), also known as '' (newline character).

UNFORMATTED data format consists of raw data, and MultiLoad will expect the data to be in the same layout as is specified in the LAYOUT statement.

UNFORMATTED data format can consist of binary data.
TEXT data format is comprised of just that -- text data (character).

So, if your incoming data consists of:

INTEGER
CHAR(10)

then with UNFORMATTED, MultiLoad will read 4 bytes for the INTEGER field, and then 10 bytes for the CHAR field.

TEXT data format was created to read Unix-type stream-oriented text data.
-- SteveF