Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Sep 2004 @ 22:27:03 GMT


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


Subj:   Load ASCII using TDAT Utility with HEX input data.
 
From:   McLeod, Terry M

I have a client sending me data to load that contains packed decimal columns. I thought that would be easy enough to handle, but it turns out that the values inside the packed fields are hexidecimal. I have been trying to use FastLoad but so far to no avail. Is there some way I can get the values changed to ASCII and loaded using either FastLoad or MultiLoad? Here's my plain vanilla code; I've tried it plus several variatoins but so far have failed to get data loaded. -- How do I need to change it?

     BEGIN LOADING TEST_LOAD
     ERRORFILES DP_WORK.TEST_LOAD_ERR_1, DP_WORK.TEST_LOAD_ERR_2;
     SET RECORD TEXT;
     DEFINE
              ID_COL         (CHAR(1))
             ,SIZE_CODE              (DECIMAL(5,0))  <==== This is defined on
     the client provided record layout as "S9(05) Comp-3".
     FILE = TEST_LOAD.DAT;
     INSERT INTO TEST_LOAD
         (ID_COL
         ,SIZE_CODE)
      VALUES
         (:ID_COL
         ,SIZE_CODE
         );
     END LOADING;

Thanks,

Terry M. McLeod
Senior Consultant
Teradata, a division of NCR



     
  <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