What does WITH HOLD option do ?forces cursor to close after commitb.Keeps cursor open after commitc.Does not allow cursor to close till all rows are fetchedd.Locks the cursore.None of the aboveKeeps cursor open after commit

BrantleyL1

 Profile Answers by BrantleyL1 Questions by BrantleyL1

• Jul 27th, 2011

This answer is wrong. It keeps the cursor open.

prasadkss

 Profile Answers by prasadkss Questions by prasadkss

• Dec 4th, 2009

When a commit is issued by a program all the cursors opened by that program are closed, but WITH HOLD option is used to retain the cursor pointer, even if the commit is used.

Answer Question  Select Best Answer

A DB2 bind is a process that builds an access path to DB2 tables.

$@1)+0$#

• Jan 18th, 2017

BIND is to your DBRM what COMPILE is to your COBOL and BIND takes your source code (the SQL) and turn it into executable code (a PACKAGE).
Hope this helps to avoid confusion!!

deepika

• Dec 18th, 2015

A bind is an executable model. It establishes the relationship between the application program and its relational data

Answer Question  Select Best Answer