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