What Does Currentdata Option In Bind Indicate?

1.	What Does Currentdata Option In Bind Indicate?
Answer» CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been CHANGED to NO. Therefore it is NECESSARY to CHANGE all the bind cards with CURRENTDATA(YES) which is default in DB2V3 & earlier to CURRENTDATA(NO). CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been changed to NO. Therefore it is necessary to change all the bind cards with CURRENTDATA(YES) which is default in DB2V3 & earlier to CURRENTDATA(NO).

Answer»

CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been CHANGED to NO. Therefore it is NECESSARY to CHANGE all the bind cards with CURRENTDATA(YES) which is default in DB2V3 & earlier to CURRENTDATA(NO).

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

Discussion

No Comment Found

Related InterviewSolutions

How Many Subqueries Can You Combine Together ?
What Is Join And Different Types Of Join?
How Many Bufferpools Are There In Db2 And What Are They?
B37 Abend During Spufi?
What Is The Command Used By Tso Users To Invoke Db2?
What Should Be Specified Along With A Cursor In Order To Continue Updating Process After Commit?
What Is The Name Of The Default Db2 Catalog Database?
When Can You Be Sure That A Query Will Return Only One Row?
What Is The Difference Between Join And Union?
What Is A Corelated Subquerry?