User Tools

Site Tools


close_pending_open_sql_cursor

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

,
close_pending_open_sql_cursor.txt · Last modified: 2016/03/09 10:15 by mihael