Archives of the TeradataForum
Message Posted: Tue, 10 Jul 2001 @ 18:59:28 GMT
| Subj: || || Re: Spurious errors with FASTLOAD of VARTEXT data with non-standard delimiting char |
| From: || || Geoffrey Rommel |
You didn't say whether your are running from MVS or a network-attached client. I strongly suspect that you are running from MVS and that
your cent sign is x'4A'. If so, I don't know how FastLoad would treat it, but perhaps it believes it to be one of these characters.
(This may or may not be relevant: on my 3270 emulator, x'BA' appears as a left bracket, even though most EBCDIC code pages say that a
left bracket should be x'AD'. x'BA' just happens to be x'4A' with the top 4 bits inverted.)
As you may be aware, there are many variants of EBCDIC (e.g., IBM-037, IBM-297, IBM-1047). I conjecture that Teradata picked one of them
way back when the cent sign was not officially standardized.