05-04-2009 12:16 PM
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.
05-04-2009 8:06 PM
Try this in the Forum
Database & OS Platforms -> SAP on SQL Server
07-22-2009 2:08 PM
using open sql now due to inconsistent performance of native sql.