Archives of the TeradataForum
Message Posted: Mon, 29 Nov 2004 @ 21:05:32 GMT
| Subj: | | Defining an input record with external decimal data |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Monday, November 29, 2004 15:55 -->
I have an application that needs to read in an IBM Mainframe based file that has fields defined in external decimal format. Decimal and
Numeric don't work, and we haven't figured out a method to use cast to get past the problem. We are using BTEQ to load this data (not a lot of
rows), though I suspect the same problem would exist for MultiLoad and FastLoad. Below is a cut and paste of sections of 5 records. Note the
over-punched sign in position 45. Data is a TSO/SPF display with hex on. First line below a set of ---- is the display version of the data. The
next two lines are first the first 4 bits of each byte, the second line is the second 4 bits, EBCIDIC format. Cut and paste is of positions 5-45
of the record.
------------------------------------------------
=COLS> +----1----+----2----+----3----+----4----+
+----F----+----F----+----F----+----F----+
+----1----+----2----+----3----+----4----+
------------------------------------------------
000002 20041031AAA176 INN0004N0000022850800{
4FFFFFFFFCCCFFF4444CDDFFFFDFFFFFFFFFFFFFC
02004103111117600009550004500000228508000
------------------------------------------------
000003 20041031AAA184 INN0004N0000008204855E
4FFFFFFFFCCCFFF4444CDDFFFFDFFFFFFFFFFFFFC
02004103111118400009550004500000082048555
------------------------------------------------
000004 20041031AAA204 INN0004N0000023962155H
4FFFFFFFFCCCFFF4444CDDFFFFDFFFFFFFFFFFFFC
02004103111120400009550004500000239621558
------------------------------------------------
000005 20041031AAA217 INN0004N0000038367404I
4FFFFFFFFCCCFFF4444CDDFFFFDFFFFFFFFFFFFFC
02004103111121700009550004500000383674049
------------------------------------------------
000006 20041031AAA218 INN0004N0000031307201H
4FFFFFFFFCCCFFF4444CDDFFFFDFFFFFFFFFFFFFC
02004103111121800009550004500000313072018
Any thoughts?
| 
