Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 15:51:14 GMT

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

Subj:   Re: Data row too long!!!
From:   Geoffrey Rommel

You can get around this by reading only part of the column:

     select substr(SqlTextInfo, 1, 16000) from dbc.QryLogSQL
     group by 1;

Now, why doesn't your original query work? The manual says that the "row" is too long, which doesn't make sense, because obviously the row exists. Apparently some internal buffer is too short. Changing respbuflen doesn't help, either.

I consider this a bug. If you can store a 64K row in the database, you should be able to select any combination of columns that is <= 64K in length. But the GSC might not agree.

  <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