When do you specify the isolation level? How?
Answer / s
Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause
WITH UR;
| Is This Answer Correct ? | 5 Yes | 0 No |
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
Mention and explain the contention situations caused by locks?
How do you pull up a query which was previously saved in qmf?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is cursor stability?
What is the difference between spufi and qmf?
What is a view? Why use it?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is view db2?
What is the meaning of -805 SQL return code?
What is netezza database?