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 .
i want code and what are used key words are ...like wrkmbrpdm screen
(q) i have a file with 3 fields empno,empname,empaddr...
here you give the empno it displays from that number to remaining empno's how?
sub file screen:
pos to:empno then enter
empno empname empaddr
so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining...
please share this answel
I have 1+ Year Experience in MAINFRAME TESTING.
After 1 Week I have an Interview With a Company on Mainframe
Please Could You Guys Please Suggest me What Sections Should
I prepare ??
___Tell Me the Topic Or Appropriate Site & Links. ??
In a CL Program after executing a SQL SP how to receive a
Output value from the SP. Just to make it clear I am sending 2
input and 1 output parameter to the SQL Stored Procedure. Now
while receiving it output parm it is failing.