Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
Answer Posted / 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 |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can we retrieve the total number of records in RPG & CLLE?
What does sqlcabc has?
When the like statement is used?
What do you mean by cursor?
How can we read records for specific member in CL? AND rpg?
What is precompiler in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is database manager in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What parameters are used to control the free space in DB2?
What is dbrm? When it will be created?
Is ibm db2 open source?
What is db2 purescale?