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 |
What is nvl in db2?
Mention some fields that are a part of sqlca.
select distinct(empid),distinct(dept),name from EMP will the above query work?
How is a typical DB2 batch program executed ?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What do the initials DDL and DML stand for and what is their meaning?
What is host variable in db2 cobol?
If I have a view which is a join of two or more tables, can this view be updatable?
What do you mean by cursor?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is a Database Request Module(DBRM)?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.