I have in one query the following components:
1) I have a Create Multiset Volatile Table with a data primary index and with commit preserve rows. This finds out the max date in the table and saves it. So it only has 1 date in the created table.
2) I have two CTE's (Common Table Expressions) One of the queries references the date in #1.
3) One Select statement to bring back the recordset I need.
When I run this I get an error:
>[Error] Script lines: 1-139 ------------------------ [Teradata Database] [TeraJDBC 16.20.00.06] [Error 3932] [SQLState 25000] Only an ET or null statement is legal after a DDL Statement.
How can I perform everything in one query without getting an error?
Would maybe be more helpful if you shared your query? Have you tried enclosing your create volatile table in a btet? There is some discussion about this on the Teradata community site here. Perhaps that would be helpful.
hmmm, the entire query runs in Toad Data Point but not in Aquafold?
Powered by IDERA