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 7924Suppose 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 25159Hi 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 14163I 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 6354Thru web page we have triggered the transaction, how can we come to know that whether it has hit the mianframes or not?
2 4647Hi 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.
4173There 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 10599Current 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 7161
How can you classify the locks in db2?
explain about maximum displacement and how to cross this limit?
When will a port of ooRexx to "XYZ" be available?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
How to override loadlib?
Would you specify freespace ce for an esds?
What is the contrast between delimited by space and delimited by size?
Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?
What does a ROLLBACK do?
WORKING-STORAGE SECTION. 01 GROSS-PAY. 05 BASIC-PAY PIC 9(5). 05 ALLOWENCES PIC 9(3). PROCEDURE DIVISION. MOVE 1000 TO BASIC-PAY. MOVE 250 TO ALLOWENCES. DISPLAY GROSS-PAY. STOP RUN. 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move
What is the difference between Global and External Variables?
Can you define path?
How is record management performed in vsam?
Can we call instream to catalog and catalog to instream?
Can you define aica abend?