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?
Answer / s
No, Because it requires an EX lock on the DBD to make
alters to the table description.
Is This Answer Correct ? | 5 Yes | 0 No |
how do we solve soc 7 and soc4 ?
What are data types?
What techniques are used to retrieve data from more than one table in a single SQL statement?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What does sqlcabc has?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
How do I add a column in db2?
Is Cursor exicutable ?
What is explain in db2?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
Is db2 a mainframe?