Archives of the TeradataForum

Message Posted: Thu, 10 Sep 2009 @ 18:43:26 GMT

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

You can read data directly from excel (max 65K rows). From within Excel choose data - import external data - new database query. Choose the dsn then enter and execute the query.

Performance improves if you increase the 'Maximum Response Buffer Size' from the default 8192 to the max which is documented to be 65477 in the help, but 1048576 in the manual. From the ODBC Data Source Administrator choose the dsn, then configure - options - advanced. This will reduce number of times odbc has to obtain another buffer from Teradata which will reduce the elapsed time. This is also true for BTEQ also--Do 'set session respbuflen max1mb' and 'set session tworespbuffs on'. The latter command will overlap fetching the next buffer with processing of the current buffer.

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