DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What does CURRENTDATA option in bind indicate ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does CURRENTDATA option in bind indicate ?

CURRENTDATA option ensure block fetch while selecting rows from a table. IN DB2V4 the default has been changed to NO. Thereforce it is necessary to change all the bind cards with CURRENTDATA(YES) which is default in DB2V3 and earlier to CURRENTDATA(NO).

(Continued on next question...)

Other Job Interview Questions