 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2006 @ 17:44:28 GMT
Subj: | | Re: ODBC Queries repeated |
|
From: | | Dieter Noeth |
Mike Dempsey wrote:
| 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) | |
A much faster way would be using ODBC parameter arrays, similar to BTEQ's PACK.
Supported since V2R6 and it was a performance boost for BTEQ IMPORTs...
Is there already an ER to add that to QueryMan?
Dieter
| |