Archives of the TeradataForum
Message Posted: Mon, 23 Aug 2010 @ 20:59:40 GMT
| Subj: | | Re: SysMaxRow size? |
| |
| From: | | John_Wight |
Thank you Barb - all good points but the size of the SQL Text is the same in both DBQL and PMCP tables - VARCHAR(31000). I've taken the
existing code and removed all the columns but 2 - my identifying column and the SQL text column (INTEGER and VARCHAR(31) respectively) and when I
run it, I still get the same 2513 error!!! There is no limit set for query logging so I should be able to get up to 31000 in the SQL log tables.
I've checked the max length in both current and DBQL history table and the highest I've seen is 29232 bytes! Even when I substring the query text
column in both queries down to 20K it still gets the same error. When I got the substring down to 1600 - it worked - go figure!!
Now, I've created a MACRO using the same two queries with NO UNION - just two queries with 2 result sets and it works fine. Only when there is
current and history rows, I get two result sets - not what we really want.
I'll work on it some more but may have to send in an incident to see what TD-GSC can come up with.
Again - thanks for your time.
JK
| 
