dbc

scalar query against an ODBC source?

Discussion created by dbc on Sep 15, 2015
Latest reply on Sep 15, 2015 by beverly

What is the best way to perform a simple scalar query against an ODBC source?

 

e.g.  SELECT count(custid) FROM customer

which returns a single numeric 4325

 

or SELECT name FROM customer where custid='1023'

which returns a single field value "John Smith"

 

or a stored procedure: CALL customeridexists(custid)

which returns 1 or 0 (true or false)

 

ExecuteSQL script step doesn't seem to return results.

Import Record (from ODBC Source) works... but defining a table with a single field seems really clunky.

 

Am I missing something obvious?

Outcomes