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
TCS,
9 14247what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
10 16372How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13660How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog or Ezytrieve and want to do using utility.
10 40818if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9272Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 9116Suppose there r 10 steps . Out fo which i want to execute 10th, 9th and 8th in reverse order without using IEBEDIT. How can i do that..???
5 17090
What is the difference between pct and fct?
What is the difference between cursor stability and repeatable read isolation levels?
What is fset?
what is an mdt (modified data tag)? Its menaing and use?
If we say that bms length of field = 0, then what does that mean?
Differentiate between hdam and the hidam databases?
Difference between cobol and cobol-ii?
What is blu acceleration in db2?
Give a brief description of db2 isolation levels?
What are various loop types supported by rexx?
When would you use abend command?
How to find the number of rows in a db2 table?
Explain the configuration section of a cobol program with examples of syntax.
What are the two types of logging in the db2 database? Explain them.
What are the different types of PL/1 files?