Interested to Buy Any Domain ? << Click Here >> for more details...
-
IBM MainFrame (5234) - IBM AS400 (1355)
- IBM PL/1 (31)
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 16739How 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 412331.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
3 8477if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9481OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
IBM,
3 32346Suppose 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 17324How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me
21 37011
Write a program to enter and display the names of students in a class using the occurs clause.
What happens when we move a comp-3 field to an edited (say z (9). Zz-)?
How to know the particular record in pf with out reading?
Explain how to detect record is locked in cobol/400? What is the solution for that?
Name the 3 common ways to create maps?
What methods are available for persisting records in an idms database? Explain.
Define the term transaction routing?
How can you access esds files from cics?
What is the main function of linear dataset?
Why select is not preferred in embedded sql programs?
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
How to run my rexx exec?
at what level s,o are defined and what they will do?
Explain what are the various isolation levels possible?
What does a deadlock mean in DB2?
