Oracle cursor for updating every row in same table marriage not dating
Fourth, we are fetching the cursor to the record in line no 9.Fifth, we are displaying the first_name and last_name of the employee in the record emp_rec in line no 10. Oracle provides some attributes known as Explicit Cursor Attributes to control the data processing while using cursors.
In Oracle its possible to get x locks on rows without creating an index, so it will be nice if this is identical in DB2....HI, Im using DB2 v9 and i wish to lock only some rows ( not the hole table ) from a table ,i've tried to use this : " Select ... For the ones who are familiar with oracle , im searching for the DB2 command that has the same effect as the oracle command " Select for update". Hi finaris, You may want to see if your application is consuming too much of the lock list. with rs ", but this statement locks the whole table !For example, if you app is only allowed to consume 10% of the lock list, your row locks will attempted to be escalated to a table lock if you are updating a lot of rows. 3- start two CLP Windows with autocommmit off ( The command is : db2 c ) Question : how to select and lock the row with the id = 1 in the first clp window and select and lock the row with the id = 2 in the second clp window ?Check lock escalations before the command and again after to see if you are experiencing lock escalation: Ex (Unix): db2 "get snapshot for database on In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. Here is a simple example: Given the Sample database of DB2. I can either lock the whole table or lock nothing :( Thank you for your efforts.