Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Nov 2004 @ 21:05:32 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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?



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016