Archives of the TeradataForum

Message Posted: Thu, 06 Oct 2011 @ 08:47:01 GMT

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

<-- Anonymously Posted: Wednesday, October 05, 2011 23:44 -->

Hi All,

I'd like to know whether I could FASTLOAD a text file into Teradata, but skipping the header and trailer records (only load the Detail records).

     H|05/10/2011
     D|20110928 000000|0|21|0|774|173|98|460|43
     D|20110928 000000|0|0|0|373|315|48|10|0
     D|20110928 000000|140|60|0|2433|69|2147|185|32
     D|20110928 000000|89|0|0|321|189|25|107|0
     D|20110929 000000|84|0|0|547|0|452|95|0
     D|20110929 000000|4213|1691|13|8309|198|2147|4262|1702
     D|20110929 000000|421|0|0|2224|0|1763|461|0
     D|20110929 000000|155|292|0|4823|202|3807|167|647
     D|20110929 000000|498|0|0|2301|755|1015|531|0
     D|20110930 000000|5712|1157|111|9644|456|984|5861|2343
     T|10

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