Answer Posted / sunil1405
Its an isolation level, It is cursor stability that “tells”
DB2 that database values read by this application are
protected only while they are being used. As soon the
program moves from one row to another other programs read
the first row.
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
What is the physical storage length of timestamp data type?
Give the name of some fields form sqlca.
What is an instance in db2?
How do you select a row using indexes in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain in brief how does db2 determine what lock-size to use?
List down the data types in the db2 database.
How to execute stored procedure in db2 command editor?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Where do you specify them?
What is the use of reorg in db2?
How do I import a csv file into db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to check last update on table in db2?
Is db2 a mainframe database?
