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 is a DBRM, PLAN ?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Can you access the DB2 Directory table using SQL?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is the physical storage length of date data type?
What is clone table?
difference between group clause and order clause
What is sqlca?
What is a Cartesian product?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is isolation level in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.