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 4932I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
2063Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
2 5113
What is collection in db2 bind?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does reorg do in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the physical storage length of the data types date, time, and timestamp?
What is dbrm? When it will be created?
Give the name of some fields form sqlca.
How do I import data from excel to db2?
How to find primary key of a table in db2?
How to create db2 table in mainframe?
What is db2 stogroup?
What is db2 look?
Mention the location where the output received from explain statement is stored.
How to get the ddl of a table in db2?
Mention the downsides of page level lock.