|
|
Archives of the TeradataForum
Message Posted: Mon, 20 Feb 2006 @ 13:34:45 GMT
Subj: | | Re: How to load EBCDIC data in mload |
|
From: | | bhull |
I have never tried to do this before, but I don't believe that you can load EBCDIC data from a "network-attached" client. I believe that you
have to have a "channel-attached" client in order to load EBCDIC data. Here is an excerpt from the manual that also implies that:
Teradata Database for UNIX Version 2, Release 2.0 (and above), Teradata for Windows NT, and Teradata for Windows 2000 allow you to establish a
character set when invoking MultiLoad. MultiLoad supports the character sets listed in Table 11. Notice that character sets containing "EBCDIC" as
part of the name are for channel-attached clients; all others are for network-attached clients.
I would suggest that you either load the data from the mainframe directly (if you have the channel-attach hardware), or convert the data to a
displayable format and then FTP it to the HP-UX box. The FTP can convert displayable formats in EBCDIC to ASCII. If you cannot do this, there
may be utilities available that can convert packed decimal and integer (comp sync) data types on the mainframe to a compatible format for HP-UX,
but I am not familiar with them.
Thanks,
Barry
| |