DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3587
Location: Australia, Melbourne
Points: 28069

Post Posted: Sun Jul 22, 2018 10:52 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Information Analyzer 11.7
Does anyone know if Information Analyzer is supported for use against Microsoft Azure SQL Data Warehouse? I am getting an error when I try to run a simple DQ rule and its looks like IA is trying to use query cursors via the ODBC or JDBC connector which is not supported by the database:

Quote:
pxbridge(0),0: ODBC Info: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.

pxbridge(0),0: Execution failed on statement select

pxbridge(0),0: ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint. (CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1,531)


SQLDW does not support client-side or server-side cursors as it is designed for dimensional table querying that retrieves the full result set.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours