Archives of the TeradataForum

Message Posted: Thu, 16 Jun 2011 @ 09:23:22 GMT

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

Madhu,

Mload does not decide which record is data and which is a header. Ideally, that could be loss of data where datafile doesnot have a header. So, Mload smartly gets input from user on deciding which records to load.

you should be using following IMPORT statement in your script:)

     .IMPORT INFILE abc
         FORMAT TEXT from 2
         LAYOUT FILE_LAYOUT
         APPLY  INSERT_FDETL WHERE fdetl_col11 = 'FDETL';

regards,

Sudhansu

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