Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 21:53:03 GMT

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

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


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023