Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2011 @ 13:36:48 GMT

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

I hate to disagree with Dave, but if your source is a mainframe, the data in the HostData column of the ET table is indeed in EBCDIC. The ET table contains records from the source that the utility was unable to interpret in accordance with the schema (e.g., .field statements in MultiLoad). Since it can't interpret them, it puts them in the ET table in byte form.

One option for reading such columns is to export them to a file and then read that file with Perl and module Convert::IBM390 (function unpackeb).

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