Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2010 @ 19:20:41 GMT

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

Is it possible to load a pipe delimted feed file containing less fields than the actual multiload script is defined for?

Example would be:

     .FIELD  TEST1 * varchar(6);
     .FIELD  TEST2 * varchar(5);
     .FIELD  TEST3 * varchar(10);
     .FIELD  TEST4 * varchar(10);

FEED Example:

     123456|12345|

I ve tried but I get the standard message Not enough data in vartext record number 1

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