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.

[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?

[sonseeahray]

@rkapoor thank you for clarifying that I need to break the SQL up into separate queries. Let me give it a go and thank you!

[rkapoor]

Let me know how it goes @sonseeahray 

[sonseeahray]

Will do @rkapoor!