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 14287what 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 16393How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13672How 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 408421.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
3 8313if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9280OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
IBM,
3 32179Suppose 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 17132How 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 36278
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
how do you specify the number of records to roll in a subfile ?
What is db2 stogroup?
What is the interactive job? What is the batch job?
How do I delete a table in db2?
Why are you looking for a change?
Does jcl support automatic restart?
how do you create an alternate index ?
What is a ci split?
What is the format of comment statement?
What is the facility that allows mainframes to be partitioned into lapars?
Can you explain control variable in online screens?
How to update data area in cobol 400 program?
What is access path in db2?
Why do we use "drop"?
