Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 19:25:16 GMT

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

Subj:   Re: Data row too long!!!
From:   Anand, Sam

Thanks Rommel. The 'Substr(SqlTextInfo, 1, 16000)' works fine.

Actually, We tried doing a Cast the column and ended up with a max value of 2886 in the query as given below.

     Select Cast(SqlTextInfo as Varchar(2886))
     from dbc.QryLogSQl group by 1;

Even having 2887 charactes gives the error 'A Data row is too long'. Not sure, what is this limit of 2886 values being allowed.

I would appreciate if somebody can let me know where and how you can change the SysMaxRow value.



  <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