Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 30 Jan 2003 @ 20:42:23 GMT

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

Subj:   Re: Retrieval of data from TPUMP Error Table
From:   Geoffrey Rommel

  How can I retrieve the data from TPUMP error table. The field HostData (last column in the TPUMP error table) has the dump of the input record. My problem is converting this back into readable format on host (Mainframe).  

Since Teradata has no ebcdic_to_latin translation table (ugh) and no general-purpose translate() function (double ugh), you will have to export the data to a flat file and translate it from there.

If you export it to a Unix host or PC, you can then FTP it to the mainframe using the "binary" option and browse it in MVS as usual. If you prefer to keep it on Unix and are familiar with Perl, you can export the data to a Unix file and then use Convert::IBM390 (available from CPAN) to convert the EBCDIC data to ASCII.

  <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: 28 Jun 2020