Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
- 2 Answers
- 5231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / narayana reddy
current of is using in cursors.
whenever we want to update and delete table data after retrived
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kamlesh
Current of is used with cursors whenever v go for update in conjunction with for update of .
1.for update of in declare stmt
2.where current of in update query after fetching
| Is This Answer Correct ? | 1 Yes | 1 No |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is difference between *omit and *nopass?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
i have a db2 variable how do u declare tht into working storage section ?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Define sqlca.
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is an alias?
What is the role of schema in the db2 database?
What is the use of predicate?
COBOL 
