Skip to content

Force_No_Scroll_Cursors=ON Produce Delete Error using OpenQuery

August 1, 2012

Introduction

 

A common procedure of the ETL process is to move data from the data source to the staging area. It is a frequent practice to delete all the content of the staging table before loading the new data. When deleting data in Sybase IQ 15.2 from MS SQL Server 2005 using openquery through linkservers, the delete command produce an error if the Force_No_Scroll_Cursors option is set to ON.

 

Description of the error

 

When executing the command


DELETE
FROM
openquery(MYIQDB,
‘select * FROM DBA.MyTable’)

 

from MS SQL Server 2005, the following error is encounter:

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider “SAOLEDB.11” for linked server “PRODIQDB”.

 

Note that MYIQDB is a Sybase IQ LinkServer.

 

Solution

 

On the Sybase IQ Server, set the Force_No_Scroll_Cursors option to OFF

 

Advertisements

From → MSSQL, SAP IQ

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: