Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2006 @ 16:27:56 GMT

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

If you are only loading a few hundred rows (or even a few thousand) you may find it is actually faster to load them using SQLA Import, or a simple CLI based application that issues individual insert statements.

The overheads required by the load utilities are fairly high when loading such small amounts of data.

As was stated earlier, unless you use the load utilities, the only mechanism for inserting data is the standard Insert statement.

You can however use multi-statement requests to send multiple Insert statements as 'packages'. (This is how TPump works)

You can do the same thing with a CLI application or with SQLA Import. However with SQLA each record in the Import file must contain all the data required for the entire query, so if your query contains 2 insert statements each record must contain the fields to be inserted for both rows.

(This may be a good thing if you are inserting data to 2 associated tables, but is unlikely to be the format of your data file when inserting to a single table.)

Mike Dempsey
Teradata Client Tools

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