Input Data Tool with ODBC driver asks for result schema before executing a query

Hi!

I'm using Input Data Tool with SingleStore and want to execute an anonymous code block.

I inserted it into the "Table or Query" field.

From ODBC traces, I'm seeing that Alteryx runs SQLNumResultCols after calling SQLPrepare but before calling SQLExecute.

Anonymous code blocks can contain Control flow statements and thus the result schema can't be determined before the query is actually executed. As a result, I'm getting "No columns returned" error.

The same problem happens when I'm trying to call stored procedure in "Table or Query" field.

photo1629450057.png

photo1629450066.png

photo1629450135.png

Input

Connectors

Database Connection

Accepted answers

All comments

mceleavey

Hi @Adalbert ,

Why are you doing any of those things?

What are you trying to achieve?

Adalbert

Hi,

I want to do some computations before selecting data.

Adalbert

danilang

Hi @Adalbert

As you've found through your ODBC traces, the target of the query has to return a fixed schema. Stored procs have to return a single cursor as well with no record count info. If you can convert your code to a stored proc, use an OleDB connection to call it.

Dan

Adalbert

Hi Dan,

SingleStore doesn't have an OleDB driver.

Are there some workarounds with ODBC?

Adalbert

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335