Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 10:45:58 GMT

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

Is their anything within the data on the header and trailer records which differentiates it from all the "normal" data records (such as spaces in certain positions etc).

We use the APPLY within the multiload to exclude rows of this ilk, E.g. APPLY LOADTAB WHERE FIRST_6_CHARS NOT IN ('HEADER','TRAILE')

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