If I have a view which is a join of two or more tables, can this view be updateable?
No Answer is Posted For this Question
Be the First to Post Answer
Explain about open switch business continuity software?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
How to resolve -917 sql code in DB2?
What does runstats do in db2?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is an instance database?
What is dbrm? What it contains?
what are the SQL codes u freequently got?
What is index in db2?
is it compulsory commitment control in journal?
How many sub queries can you combine together ?
how to identify the pseudo conversation by seeing the program