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
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Can we update view in db2?
How to retrieve rows from a db2 table in embedded sql?
What does a deadlock mean in DB2?
What is with ur in db2?
Give the name of some fields form sqlca.
What is a db2 tablespace?
What does db2 stand for?
How do I change the column size in db2?
What is the function of logging in the db2 database?
Why cursor is used in db2?
How do I create a view 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?
can all users have the privilage to use the sql statement select * (dml)?
How to get the ddl of a table in db2?