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 14331what 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 16447How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13693How 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 40888if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9311Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 9146Suppose 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 17161
Brief description of inline procedure of jcl.
What is bind package and plan in db2?
What is meant by an isolation level?
can any body give me any website for getting help on mainframe projectts in banking domain.
Tandem COBOL Interview questions (on TACL,SCOBOL,ENSCRIBE,PATHWAY0
Can you define temporary storage?
How do you define a variable of comp-1 and comp-2?
what are the codes returned by the ams (access method services) command during the execution in vsam?
What is schema in db2?
Name the various locking levels available?
How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?
How will you return the number of records in table?
What is a buffer in memory?
What is coalesce in db2?
What is the difference between structured cobol programming and object alternativelyiented cobol?