What is the maximum number of tables that can be stored on
a Partitioned Table Space ?
- 1 Answers
- 5462 Views
- IBM, I also Faced
- E-Mail Answers
What does sqlcabc has?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
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
What is subquery ?
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.
0 Answers ITC Infotech, Syntel,
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is the difference between base table and view?
Is the primary key a clustered index?
What is dbrm? What it contains? When it will be created?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Why select is not preferred in embedded sql programs?
what is the name of the default db2 catalog database?
COBOL 
