Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Sep 2004 @ 11:48:52 GMT


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


Subj:   Packed Decimal through FastLoad
 
From:   David Clough

Does anyone know whether a FastLoad can accommodate a Packed Decimal input field? We've got input files that have columns defined as packed decimal and we'd like to load it straight into a table (which as has the column defined as Decimal).

In the past, we've translated the input file definition such that each of the columns, of which were Decimal columns from the source system, are translated into unpacked numeric values.

As an example, we have Decimal (6,3) unpacked into the file as 'NNN.NNN', defining them in the FastLoad as (FORMAT '9(3).9(3)')

It just seems to me that there must be an easier method.


Dave Clough
Database Designer
Database Design Group



     
  <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: 15 Jun 2023