Tab Delimited Flat file and Mload

Tools & Utilities
Enthusiast

Tab Delimited Flat file and Mload

Hi all,
My requirement is to insert the data from a TAB delimited flat file using Multiload Job script.

I used the following in the Mload:

.IMPORT INFILE customers.dat
FORMAT VARTEXT '09'XC
LAYOUT new_cust_layout
APPLY LABELA;

*Note that '09'XC-->indicates the TAB key.
It works fine in Windows Teradata Demo S/W.But it fails in MP-RAS.
It throws the following error:

"an unexpected MultiLoad
phase, data acquisition, was reported by the RDBMS."

How can we do it to work with UNIX MP-RAS?
Any help is appreciated.
Thanks in advanced
1 REPLY
Enthusiast

Re: Tab Delimited Flat file and Mload

Hi,
It works with '09'XC in Unix too.The problem was due to the tool which I had used to generate the test flat file.
Thanks,