Archives of the TeradataForum
Message Posted: Thu, 12 Dec 2002 @ 16:41:17 GMT
| Subj: | | Re: Compatibility issues between TUF 6.0.1 and TUF 6.1.1 |
| |
| From: | | rmhsmd |
? (This is Bob Hahn from NCR).
57202 is an RFC for an optimization to limit the fields sent to those used--it allows greater pack when a particular dml only uses a
subset of the fields in a layout. For example assume a big input record and conditional apply of one or more dmls each of which uses a
subset of these fields. With 57202 the max pack would be based on the dml with the most fields rather than the count of fields in the
layout.
The original problem statement appeared to be an attempt to use more fields than the Teradata limit of 507.
Pack 1 is not a 'workaround'--it would kill throughput by not using multi-statement requests at all.
The pack should be set to a value that will result in 507 fields or less in the using clause. If there were 23 fields in the dml, the
max pack would be 22 since 22*23=506.
| 
