Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4909 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What's The Error Code For Unique Index Voilation?
Which components manage deadlocks in db2?
What is the syntax for creating a table in the db2 database?
What action db2 takes when a program aborts in the middle of a transaction?
What is the use of reorg in db2?
How can deadlocks be resolved?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain dclgen.
What are the 2 sqlcodes that are returned?
What is sqlca’s maximum length?
What is a storage group (stogroup)?
Define sqlca.
What is clone table?
What is copy pending status in db2?
