Using QMF.
Tweet This Post

WHERE is for Rows and HAVING is for Groups
Tweet This Post

Delete From Table1Where Id In (Select Id From Tabel1 As Temp Group By Id Having Count(*) >1)
Tweet This Post

CS RR UR( added new for DB2V4 which stands for uncommited read which allows to retreive records from the space which has exclusive locks also but data integrity will be affected if this option is used )The best available option for data integrity & data concurrency is CS.
Tweet This Post

TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retreived faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended.
Tweet This Post

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).
Tweet This Post

sql statement gets executed when we open cursor
Tweet This Post

The answer is 18 characters.
Tweet This Post

NO
Tweet This Post

ZERO
Tweet This Post