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?