Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: What is dataparcel?
From:   Geoffrey Rommel

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023