Archives of the TeradataForum

Message Posted: Mon, 23 Aug 2010 @ 18:36:51 GMT

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

I'm trying to create a view with a UNION ALL. OK - not difficult right? (I've checked that the projected columns are same time/size).

Both sides have same query (i.e. projected column results) except for the table references (2 different sets - one set is DBC.qrylog & DBCqrylogsql and the other pair is PMCPINFO.DBQLOGTBL & PMCPINFO.DBQLSQLTBL_Hst - their 'history equivalent). When I run each query the results return OK. When I UNION ALL them together I get a 2513 error (A data row is too long). The error manual description says that the returning row is larger than SysMaxRow(??). I thought that might be in the DBSCONTROL table - but there is no reference and can not find reference to that in other DBA manuals??? I assume that the max row size is 64KB and because either query returns rows OK, it must be something in the UNION ALL.

The SQL text from DBQL data is projected but that in itself is only 31KB and that is TRIMmed. There are no GROUP BY or ORDER BY clauses which might extend the row size.

Any Clues, etc.?

Thanks in advance for any feedback.

JK

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