Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 09:50:09 GMT

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

Hi Anand,

I checked out the meaning of error no 2513 in teradata help document. It contained the following information:

2513 A data row is too long.

Explanation: The length of the row specified by the caller is greater than SysMaxRow, the maximum length allowed for any row in the database. The row could be either one specified directly by the user, or an intermediate results row required for query processing.

This indicates that a row is too long. Query processing often requires intermediate results rows that are longer than the data being selected. For example, ORDER BY and GROUP BY columns require sort keys that increase intermediate results row size.

You may look for changing the value of the value of SysMaxRow. I am not so sure whether u can do that. Alternately you could think about removing the group by clause and change the query to:

     select SqlTextInfo from dbc.QryLogSQL (works fine)

Hope I answered your question.

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