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 |
Can you search give an array in the WHERE clause of a db2 query?
define clustering index.
how to get duplicate records from tables?write qurey for this?
How do I delete a table in database?
In terms of DB2 indexing, what is the root page?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is the use of db2?
Can we install 2 different versions of Db2 on same mainframe?
what is difference between Plan and Package
Can a Db2 table data be retrived through JCL?
Why cursor is used in db2?
What is difference between alias and synonym in db2?