can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

What is isolation level?

4 Answers  

---

What is a data page?

1 Answers  

---

What is a view? Why use it?

2 Answers  

---

What are the contents of a dclmgen?

0 Answers  

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

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?

2 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---