topic Re: Deallocate cursor - native SQL in Application Development and Automation Discussions

Deallocate cursor - native SQL

Former Member — Mon, 04 May 2009 11:16:32 GMT

Hi Experts,

I am writing a native SQL query. Can anyone know why the following native SQL statement is giving me a dump.

The database is MS SQL 2005



exec sql.
  open dbcursor for 
    select statement....
endexec.

exec sql.
  close dbcursor
endexec. 

exec sql.
  deallocate dbcursor
endexec.

I get a dump when i use deallocate dbcursor.

Can anyone let me know how can I use deallocate.

Regards,

Abdullah.

Former Member — Mon, 04 May 2009 19:06:49 GMT

Try this in the Forum

Database & OS Platforms -> SAP on SQL Server

Former Member — Wed, 22 Jul 2009 13:08:32 GMT

using open sql now due to inconsistent performance of native sql.