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 13879what 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 16064How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13499How 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 404791.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
3 8164if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9070OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
IBM,
3 31992Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 8994Suppose 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 16914How 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 35482
How to use the same COBOL program in Batch and CICS on lines? explain with an example
What is dbrm?
What is the copy idms subschema-binds?
i have 10 names in an array and my name is one of them also array is not in sorted order i need to display my name using index how will i do this
what are the thress bms options?
Define the term transaction routing?
What is Comp-2?
how we sort two input files based on a common column and giving one o/p file please send me the coding logic?
Is it possible to left uncode disp?
example for sub strings ? and refernce modifications whit output pls
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
How to call one program from another program in RPG? please help me with the code
What is database descriptor?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the use of qsam?
