Archives of the TeradataForum

Message Posted: Sun, 20 Apr 2008 @ 09:34:32 GMT

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

Batch array is standard JDBC implementation and a good reference is the Sun Java documentation ...

Fastload mode is switched on by using TYPE=FASTLOAD in the connection URL , the number of sessions is specified by using the SESSIONS=n parameter in the connection string.

This automatically converts the batch array to use fastload internally. the table needs to be empty just like normal fast load and all other fastload restrictions apply.

You need to remember to set autocommit to false while using fastload mode, if you are sending the records in multiple batches... (too many records per batch may result in out of memory in the JVM.This could also cause AMP lock table overflow in the normal batch array mode)

regards

Joseph D'silva

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