Home Page for the TeradataForum
 
https:

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


Dieter



     
  <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: 28 Jun 2020