Archives of the TeradataForum

Message Posted: Fri, 15 Jul 2011 @ 15:39:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sukul,

The 'HostData' field is the actual data row sent from the client (in your case presumably a mainframe) to the Teradata system. But it is now in ASCII, not EBCDIC.

The other fields in that table will show you which part of your ML script caused that row to be sent (look in the ML manual, Chapter 2, "Handling Multiload Errors"). Look at that part of your script to determine the fields that get sent and their format. That will then tell you which bytes in the HostData field correspond to the fields from the client system.

That route can be tortuous. The ML manual describes (same section as above) a different route which you may find easier.

Give eitehr a go.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>