Archives of the TeradataForum

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

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

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>>