What can the Locate option of the Repair Utility accomplish?
Answers were Sorted based on User's Feedback
Answer / sreesh
Locate block in a reparir utility is used to lopcate a
page,RID, key in an INDEX etc.
The locate statement can be follwed other repair statement
like DELETE.
| Is This Answer Correct ? | 0 Yes | 0 No |
What techniques will be used to avoid deadlock??
How does db2 sample database connect?
can any one expalin check point with an example?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Where would you find information about the type of database authority held by the user?
What is runstats and reorg in db2?
What is the difference between oracle and db2?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
what is SPUFI ?
What is the difference between Primary key and unique index?