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