Archives of the TeradataForum
Message Posted: Thu, 30 Aug 2012 @ 15:53:10 GMT
<-- Anonymously Posted: Thursday, August 30, 2012 09:50 -->
The company upgraded everyone to SQL-A Version 13.10.0.08 recently. A program that has over a hundred statements ran well with the previous version of SQL-A, but with this new version after so many statements, mostly creating Volatile Tables this happens, often. We get Error 3932. It?s like some switch is turned to the executed in parallel, instead of Executing in sequence. Statement 98 is nothing special, not complex, it is similar to a dozen or more like it in the previous 97 statements, and once it like a dozen afterwards.
Anybody have any thoughts as to why this happens?
Statement 96: CREATE TABLE completed. 0 rows processed. Elapsed Time = 00:00:45 Statement 97: SET completed. Elapsed Time = 00:00:02 Statement 98: CREATE TABLE Failed.?? Only an ET or null statement is legal after a DDL Statement. Output directed to Answer window
This new version of SQL-A is frustratingly harder to use than previous versions.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|