We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

sonseeahray
8 - Asteroid

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.

 

sonseeahray_0-1624972094805.png

 

4 REPLIES 4
RishiK
Alteryx
Alteryx

@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
8 - Asteroid

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

RishiK
Alteryx
Alteryx

Let me know how it goes @sonseeahray 

sonseeahray
8 - Asteroid

Will do @RishiK!

Labels