Archives of the TeradataForum

Message Posted: Thu, 14 Nov 2002 @ 20:24:16 GMT

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

PPS: On your .FIELD statements in Mload will be simplfied by specifing the exact data type of the target table for each input column... Doing it this way will speed up both the FastExport and Mload becasue you eliminate internal datatype conversions (source/text/varchar/target) which take alot of overhead!

PS: Doing the FEXP/MLOAD the way I explained requires you to NOT concatenate the FastExport output, but to use (or cast) each individual column in the select statement to the internal data type of the intended TARGET table

On FastExport you need:

.EXPORT OUTFILE "yourfile" FORMAT FASTLOAD MODE INDICATOR;

On MultiLoad you need this:

.LAYOUT INPUTLAYOUT INDICATORS;

and this

.IMPORT INFILE "yourfile"
      LAYOUT INPUTLAYOUT
      FORMAT FASTLOAD
      APPLY "yourlabelname";

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