|
|
|
Forum Member
 
Group: Forum Members
Last Login: 6/8/2007 9:40:00 AM
Posts: 42,
Visits: 1
|
|
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
Ganesan
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 6/8/2007 9:40:00 AM
Posts: 42,
Visits: 1
|
|
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,
Ganesan
|
|
|
|