When is the skeleton cursor table created?
Answer / s
Skeleton cursor table is created when a new plan is bound.
| Is This Answer Correct ? | 3 Yes | 0 No |
Give a brief description of db2 isolation levels?
Return code 100 means?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is an access path?
How can deadlocks be resolved?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is the maximum size of varchar data type in db2?
What is collection in db2 bind?
how can u understand the end of the table ?
Which isolation level provides highest data integrity?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop