Differences

This shows you the differences between two versions of the page.

--- close_pending_open_sql_cursor [2016/03/09 11:15]
+++ close_pending_open_sql_cursor [2021/04/05 11:23] (current)
@@ Line 1: / Line 1: @@
+====== Close Pending Open SQL Cursor ======
+Opening an SQL Cursor may leave the cursor open even after a CLOSE command. The system uses this technique to optimize the access time by leaving the ODP open for any further request. To close these SQL cursor ALCOBJ can be used.
+  ALCOBJ OBJ((MYLIB/MYFILE *FILE *EXCL)) CONFLICT(*RQSRLS)
+See http://www.mcpressonline.com/sql/techtip-wresting-your-files-away-from-sql-pseudo-close.html
+{{tag>sql ibm}}