Archives of the TeradataForum

Message Posted: Thu, 12 Dec 2002 @ 08:51:20 GMT

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

The Teradata limit for using clause is 507 until 5.0 when it becomes 2560. The using limit is actually the same as the max lifetime table columns as documented in the SQL Reference Volume 4 DDL. Sometimes you hit a concrete steps limit at a less-than-max pack rate...I haven't seen the 8001 message and don't see it in the messages manual. Did TPump adjust the pack? Letting TPump figure it out is very time consuming--you might do that once but production jobs should definitely specify the correct pack value....

(Pre 5.0 ODBC and OLE-DB restrict parameter arrays to 256. For Teradata 5.0 they will allow Teradata to enforce the limit.)

ODBC and OLE-DB support only 256 parameter array columns until 5.0 when both allow Teradata to enforce the limit.

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