We've bem running and MLOAD and we get the following error "UTY0805 RBDMS failure, 3791: Mload target table cannot be a referenced tble or contain any referential constraint(s)."
Is there a way to ovelrap this issue? Should I use another function then the Mload?
I'm using the Mload V.13.
Can anyone help?
Thanks a Lot.
MLoad doesn't support loading tables with Foreign Keys (afaik unless it's a soft FK REFERENCES WITH NO CHECK OPTION) .
You could switch to TPump or load into a staging table and the use SQL.
Hi I am new to teradata, I am facing problem in MLOAD with respect to single column load.
my file contains
and my MLOAd utility is throwing error while reading the data from the file.
i am using the layout like this:
.layout alayout indicators;
.field a * varchar(20);
.DML LABEL ADML;
INSERT INTO tbl1(
.import infile file1
I am getting the erro:
UTY4015 Access module error '35' received during 'read' operation
on record number '3': 'EOF encountered before end of record
Please suggest me if any thing wrong in the script.
You should post new questions to new threads.
Your script looks ok, FORMAT VARTEXT is correct.
Is any data loaded?
Is it the correct end of line for your operating system, Win/Unix?
Is there a linebreak after the last input row?