Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the clustering index in the db2 database?
What is meant by the attachment facility?
What are host variables in db2?
What is a page in db2?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
how to resolve -805. give clear explination for that
how can u understand the end of the table ?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is the role of data manager in the db2 database?
What are types of indexes?
can we view the access paths created by dbrm ? how ? thx