Error file using Multiload

Tools & Utilities
Enthusiast

Error file using Multiload

Hi,

Multiload will automatically creates Error table while loading from file to database. Is there any way to generate error files on unix box instep of error tables. Please help me in this case.

Thank you,
Regards,
Kiran
3 REPLIES
Enthusiast

Re: Error file using Multiload

Hi,

No post from any one. please help me in this case.

Is there any way to pass the rows which are produced errors while loading with mload. The key words DISPLAY ERRORS,NOSTOP will show the errors on standard output but i want to redirect these to a file on unix. please help me inthis case.

Thank you,
Kiran
Teradata Employee

Re: Error file using Multiload

You're asking about two entirely different things.

The DISPLAY ERRORS and NOSTOP only apply to the client-side conversion from delimited VARTEXT to VARCHAR fields (with binary length prefix) - prior to sending the record to the Teradata database.

That has no relation to errors which the Teradata database may detect and record in the two error tables when the data is received and when the data is applied. If the error tables are non-empty & not dropped at the end of the MultiLoad, you can query them or export the data - using BTEQ or some other tool.

Re: Error file using Multiload



HI Kiran

In mload script after
".end mload" add this statement,

.os bteq <script1.txt;

.quit

-------------
in script1.txt write something like this :

.logon

.export report FILE=D:ew\bt\ACCTSTEST.TXT;

select * from FINANCIAL.er_ACCTs_TEST;
.export reset;
.quit

/* from error table er_ACCTs_TEST you are exporting into another file.*/

--------------------------------------------------------------