What is a cursor and what is its function?
- 2 Answers
- 4919 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is a plan and how do you refer the plan in the program?
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 techniques will be used to avoid deadlock??
When will you chose to run RUNSTATS?
What is the difference between group by and order by?
What are the disadvantages of PAGE level lock?
What is meant by explain?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What will the DB2 optimizer do?
What techniques are used to retrieve data from more than one table in a single SQL statement?
When reorg is used?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
COBOL 
