Archives of the TeradataForum

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

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

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>>