Archives of the TeradataForum

Message Posted: Tue, 23 Oct 2007 @ 20:54:40 GMT

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

Hi sash,

Yes, you can import multiple files in single MLOAD. But you can't import multiple files in single IMPORT.

Pls find the following syntax.

     .IMPORT INFILE &DATA_DIR./&file_nm_1
     Layout layout_name
     FORMAT VARTEXT '|'
     APPLY UPSERT_DML;

     .IMPORT INFILE &DATA_DIR./&file_nm_2
     Layout layout_name
     FORMAT VARTEXT '|'
     APPLY UPSERT_DML;

Thanks,

Ramu.

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