Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 14:30:20 GMT


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


Subj:   Re: Use of HELP TABLE command in FastLoad
 
From:   Michael Larkins

Hi Prasanna:

The use of the HELP TABLE command in FastLoad only eliminates the need to add field definitions to your DEFINE. You still code a DEFINE, but it only contains the FILE statement to identify the input file to read (or INMOD).

The catch is that you must use the column names for any specification regarding substitution (:fieldname) within your INSERT. The other requirement is that the fields in the record must all be in the exact same order and same data type as that of the table. So, if you have character data coming in and a decimal column, the HELP TABLE will not work.

As an alternative: if you record is exactly like the table definition, you can do a Self-defining INSERT. To do this, you use the same DEFINE as mentioned above and do not use the HELP TABLE. Instead, you code the following:

INSERT INTO .*;

The Fastload software recognizes the fact that both are the same and simply matches up data to columns and build the rows.


Hope this helps,

Michael Larkins
Certified Teradata Master



     
  <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: 23 Jun 2019