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 7916Suppose 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 25151Hi 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 14139I 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 6347Thru web page we have triggered the transaction, how can we come to know that whether it has hit the mianframes or not?
2 4642Hi 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 5083How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.
4165There 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 10590Current 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 7153
Can records be accessed randomly in esds?
can any one exaplin about Decision Tables in test region with good example
Define db2 and its databases?
How can values be passed from the job stream to an executable program?
If I have limited experience with Rexx or it's been a long time since I've used it, what kind of help is available to get me started?
What is idms-restart ?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What kind of database is db2?
Explain the difference between and exec cics xctl and exec cics start command?
How do you reference the fixed block file formats from cobol programs
What is link edit in cobol?
What are the prerogatives?
Suppose if I have updated few fields of adabas file using update command, and after that I used display to see that field get updated or not. If in display it showing nothing or record did not get updated then what can be the possible reasons?
State the maximum number of tables that can be joined?
What are the different types of PL/1 files?