Mload on a referenced table.

Tools

Mload on a referenced table.

Hi, 

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. 

4 REPLIES
Senior Apprentice

Re: Mload on a referenced table.

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.

Dieter

Re: Mload on a referenced table.

Thanks Dieter i'll try that and let you know.

Re: Mload on a referenced table.

Hi I am new to teradata, I am facing problem in MLOAD with respect to single column load.

my file contains

123

234

4567

678

 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(

 a                            

)

VALUES

(

:a);

.import infile file1

format vartext

layout alayout

apply adml;

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.

Senior Apprentice

Re: Mload on a referenced table.

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?

Dieter