Archives of the TeradataForum
Message Posted: Thu, 15 Feb 2007 @ 15:51:14 GMT
| 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.