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 14716what 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 16738How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13806How 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 41233if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9481Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 9270Suppose 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 17324
Explain how can return codes be tested before execution of a job step?
Where is the vsam ksds placed?
Differentiate between the joblib and the steplib statements?
What is schema in db2?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What is dbrm library?
Explain what you understand by passing by value.
How can you count the number of rows from a table tab?
can you please let me know if there is any walkins for COBOL/PLI/DB2/IMS/JCL in pune other than IBM and ITC infotech
What are the cics commands associated with task control?
Explain the like inverted list?
What is the use of disp parameter?
What is the use of lds (linear data set)?
Matching Logic in Jcl not in cobol.Could any one please answer this question
Explain how and where is the twa size set?