Archives of the TeradataForum
Message Posted: Sun, 04 Apr 2004 @ 21:41:22 GMT
Subj: | | Re: Ab-Initio and "AMP lock table overflow" |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Sunday, April 04, 2004 16:44 -->
Appreciate the response from Todd and Sam.
Yes, the API load uses ANSI session mode and apparently its hardcoded, hence one cannot change it. We have asked the vendor to gives us the
flexibility to change the session mode.
The component in question does not have Utility load option which would have given the flexibility to change the session mode.
Looking to use Tpump or place a check to make sure we don't insert large number of records using the API mode.
|