Explain db2.
No Answer is Posted For this Question
Be the First to Post Answer
How to see the structure of db2 table??
What is a clustering index?
What is meant by concurrency?
What is the maximum size of varchar data type in db2?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is dbrm? What it contains?
How can you get the number of rows impacted by the last executed query?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
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 do you check for a null value in a db2 column?
What is the SQL query to select, delete and get count of duplicate rows in DB2?