Error: Connect In-DB (1): Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata

sonseeahray

This error Error: Connect In-DB (1): Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database](-3576)Data definition not valid unless solitary. only occurs when I attempt to run this query from within Alteryx In-Database. The attached query runs fine within Teradata itself.

Changes.docx

rkapoor

@sonseeahray this sort of error normally occurs when you have a multi-statement request. Looking at your SQL, it looks like you are wanting to run multiple SQL queries at once in the in-db tool.   The in-db tool will run this as one transaction and therefore Teradata will treat this as a multi-statement request. 

Can you split the SQL queries out into separate in-db tools?