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 14295what 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 16397How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13677How 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 40848if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9283Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 9133Suppose 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 17137
Is ibm db2 free?
Define primary objective of cics?
In a Natural program i used the below code for report FORMAT LS=132 PS=60 And down the line I want to change either LS/PS like FORMAT LS=120 PS=50, is it possible? How it will work?
Define where and its usage?
Suppose I have a ksds file. I have a records like 1,2,3,4,5,6,...100. I want to read using dynamic mode like from 10 the record onwards like, 10,12,14,16,18,....60. Wat is the command for this?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what is db2 restart?
Explain how does idms communicate with cics?
How to pass data to a program that is coded in an exec statement?
what is u r recent task in insurence project?..plz tell how to tell this.
What is the mainframe computer?
Explain the function of //cntl statement?
In job processing, what happens in conversion stage?
Is it possible to move the alphanumeric variables to a numeric variable?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?