SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
2 7830Suppose i have a file with 10 recs and i want to skip only the 7 th record and copy the rest into another file. How do i do it using SORT?
7 24927Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
IBM,
6 13966I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
2 6268Thru web page we have triggered the transaction, how can we come to know that whether it has hit the mianframes or not?
2 4535Hi can anybody tell me about Mainframe batch testing and how is it done. I am totally new to mainframe testing. Thanks in Advance.
IBM,
1 5007How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.
4126There is subprogram and which is used in more then 200 modules. when we made changes to subprogram is it required to RESTOW all the main programs? If YES means how i can restow all 200 main programs at a time.
HCL,
3 10431Current version of GDG is ID.GDG.FILE.G0001V00. JCL has procedure with 2 steps like below, What will be the output file name in each step ? PROC starts Step 1 has ID.GDG.FILE(+1) Step2 has ID.GDG.FILE(+4) PEND Similarly, JCL has 2 steps in 2 separate procedure. What will be the output file names here ? PROC starts Step 1 has ID.GDG.FILE(+1) PEND PROC1 starts Step2 has ID.GDG.FILE(+4) PEND
FIS,
2 7032
Can anyone provide me the source code for LOC(lines of code) counter written in REXX language which can run on IBM mainframe z/OS V1R4. The LOC counter should be able to count the comments,lines of code,blank lines in a COBOL program and JCL's
Explain the difference between record occurrence and record type in idms?
When output dataset space is required, what quantity categories are used?
how do you create an alternate index ?
What is condition checking in jcl? Is this possible?
What is the difference between oracle and db2?
Explain how can the disposition of sysout datasets be set for an entire jobstream?
What is isolation level in db2?
What are various search techniques in cobol? Explain.
What is the maximum of key fields and search fields allowed in a segment?
Ap wkur,=p5 where wkur is a label?
Explain the difference between dfhcommarea and tsq?
what is the meaning, the advantages and which are the types of evaluate statement?
What is the purpose of relative record data set used in vsam?
In sms datasets, what is the function of the dd mgmtclas keyword?