Archives of the TeradataForum

Message Posted: Wed, 19 Oct 2011 @ 22:08:17 GMT

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

Thanks for the info about using Multiload to only load detail record, skipping header and trailer. Since the header and trailer record foramat are different from those of the detail records, my issue now is that it complains about it:...:

     **** 08:51:35 UTY4017 Not enough data in vartext record number 1.

My script:

     .IMPORT INFILE INFILE
      format vartext '|' nostop
      LAYOUT inlayout
      APPLY INSERT_VCCI where rectype = 'D';

How do i get around it?

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