 |
 |
Archives of the TeradataForum
Message Posted: Thu, 30 Jan 2003 @ 20:42:23 GMT
| 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.
| |
