Archives of the TeradataForum
Message Posted: Thu, 15 Feb 2007 @ 21:53:03 GMT
Subj: | | Re: Data row too long!!! |
|
From: | | Dieter Noeth |
Sam Anand wrote:
| Even having 2887 charactes gives the error 'A Data row is too long'. Not sure, what is this limit of 2886 values being allowed. | |
What's your Teradata release?
I tried your original query and it run without error on my V2R6.2
But "select distinct SqlTextInfo from dbc.QryLogSQL" failed (as expected), because of the implicit "Order By"
| I would appreciate if somebody can let me know where and how you can change the SysMaxRow value. | |
You can't.
Database Design
Chapter 16: System-Level Capacity Planning Considerations
Determining Available User Table Data Space
Rules for Using the Spool Space Equations
Dieter
|