IBM's flagship relational database management system
by pradeepgowda » Thu Jan 28, 2010 11:11 am
in case when a program abend will the cursor(ie opened) be closed if withhold option is specified in declare cursor.
-
pradeepgowda
-
- Posts: 40
- Joined: Mon Jan 04, 2010 4:17 pm
- Has thanked: 0 time
- Been thanked: 0 time
by dick scherrer » Fri Jan 29, 2010 12:29 am
Hello,
When a process ends (normally or an abend), cursors are closed.
Hope this helps,
d.sch.
-
dick scherrer
- Global moderator
-
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Return to DB2
-
- Cursor with CASE expression
by saurabhgupta86 » Sun Jul 14, 2013 4:17 pm
- 1 Replies
- 2543 Views
- Last post by dick scherrer
Mon Jul 15, 2013 1:02 am
-
- Cursor with Select Case
by itamar rocha » Tue May 06, 2014 10:26 pm
- 0 Replies
- 2222 Views
- Last post by itamar rocha
Tue May 06, 2014 10:26 pm
-
- converting dynamic cursor into static cursor
by rupa888 » Mon Jun 17, 2013 5:36 pm
- 5 Replies
- 3005 Views
- Last post by dick scherrer
Wed Jun 19, 2013 6:43 pm
-
- END OF CURSOR AND NO ROWS FOUND IN CURSOR.
by sinmani » Fri Oct 04, 2013 5:28 pm
- 5 Replies
- 6229 Views
- Last post by Akatsukami
Mon Oct 07, 2013 10:36 pm
-
- Case in Mainframe SQL
by ontheDB » Wed Mar 03, 2010 7:50 pm
- 4 Replies
- 2384 Views
- Last post by GuyC
Tue Apr 27, 2010 2:18 pm