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.