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 14258what 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 16375How we copy a program from production region to development region.What is the process & syntax ?
CTS,
3 13664How 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 408311.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
3 8304if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
4 9273OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
IBM,
3 32162Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
3 9120Suppose 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 17105How 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 36197
Which command is used to connect to a database in DB2 ? Give the Syntax.
Why is it necessary that file needs to be opened in I-O mode for REWRITE?
define cond parameter in jcl?
How to run cobol program using jcl?
2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic
List in order the hierarchical levels of jcl?
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
What are the pertinent COBOL commands?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
what is meant by s0c-07 system abend codes?
Define a junction record in idms?
how can we run a batch job?
explain icm instruction?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
Is the order of the when clause important in an evaluate statement? Is the order of the when clause significant in an evaluate statement?
