Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Mar 2003 @ 16:17:12 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Fastload Query
From:   Michael Larkins


Loading a delimited file is one of the newer capabilities of Fastload. To accomplish this do the following:

1. DEFINE statement - all fields are VARCHAR with the longest possible length of characters in each (between delimiters)

2. use the SET RECORD command to define record as VARTEXT followed by your delimiter in quotes

That should pretty much take care of it for you. If you need an example, the manual has one and additional verbage on using this technique. Please be aware that Fastload will not run as fast using delimited files as it does with raw data because it must look at each character position to determine if it is a data character or a delimiter.

Good luck, Mike

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