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 11347what 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 13560How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 12214How 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 37540if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 7659Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 7767Suppose 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 15208
Can you define mapset?
How to get the ddl of a table in db2?
Explain how do you dynamically set the cursor position to a specific field?
What is the maximum size of a char data type in db2?
What is the use of dclgen in db2?
What the difference is between continue and next sentence?
How are data passed from jcl parm to assembler program?
Explain the difference between pseudo-conversational and conversational?
Explain about open switch business continuity software?
Explain the function of the dd dcb keyword?
i want to store 20 digits . how will u do it in cobol ?
What is currency in idms?
What parameters can be used to limit the number of records written to a sysout dataset?
what are the codes returned by the ams (access method services) command during the execution in vsam?
A dd statement consists of 4 fields. Name them?