Archives of the TeradataForum

Message Posted: Thu, 30 Aug 2012 @ 15:53:10 GMT

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

<-- 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.??[3932] 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.

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