Can I Write Errored Records into a File In MLOAD?
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Teradata Tools and Utilities » Can I Write Errored Records into a File In...
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Can I Write Errored Records into a File In... Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ravindrareddy
Posted 9/4/2009 9:50:29 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 11/6/2009 11:56:30 PM
Posts: 19, Visits: 37
Hi ALL,
While loading data from flat file to Teradata table using MLOAD,few records has bad data.Due to these records MLOAD got failed and this data hasn't been captured in ET tables.
So I have used "DISPLAY ERRORS NOSTOP" command to make sure that MLOAD get completes without fail.But I want to write such bad records into a file for furthur investigation.

Can someone help me in acheiving this task please?


Thanks In Advance,
Ravi

Learn And Share...

URS

Ravindra Red

Post #16762
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:43pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.078. 6 queries. Compression Disabled.