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 11311what 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 13497How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 12174How 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 37480if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 7634Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 7734Suppose 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 15178
What is the difference between the mro & isc?
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
how to run batch program without jcl?
What do you mean by between and in? Is between inclusive of specified range values?
What is the use of the program list table?
Explain about logical data model of idms?
What is the difference between the positional and keyword parameters? Give examples.
What is the difference between an obtain next and obtain first in idms?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Explain the system transid cemt?
What is the default value(s) for an initialize? What keyword will allow for an override of the default?
What is cics load command?
what is need of start 0? In steed of
What is the purpose of store statement?
what is a jcl?