What is the maximum number of tables that can be stored on
a Partitioned Table Space ?
select 100 records from million records ?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Are views updatable ?
how to resolve -805. give clear explination for that
What is multi row fetch in db2?
What is sqlca’s maximum length?
how to copy the host variables from ps file into cobol program other than include statement
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
why we create view.
Explain the benefits you can get from mainframe connect?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.