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 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. ??
I have 3 years of exp as a mainframes tester in a leading IT
company, now am looking to change my company. Could you
please let me know, what are the interview questions/topics
i should prepare.
Your suggestions are truly valuable for me :)
input= ,,,, mainframe training ,,, hyderabad ....
output1=$ mainframe training in hyderabad location$
output2=**** mainframe training in hyderabad location ****.
In this pgn when we give input considering the spaces the
output is displayed in this format.Like in the place of ,,,,
$ should be displayed likewise.So please helpmeout.
I have one input file and some 40 tables, I want to read
input file and compare the input file value with the table
value if it is present then we have to update with new
value, this should be repeated for all 40 tables and we are
reading only one input file, for this is there any REXX
program or job or routine to accomplish above requirement.
components of the requirements;
1. One input file
2. 40 DB2 tables
3. we have to read from the input file and compare with
table value, if present then update with new value (this
should be recurssive for all 40 tables for every record of
4. quick help is appreciated.
can we view the access paths created by dbrm ? how ? thx
run jcl for cobol+db2 pgm?..
//step001 exec pgm=ikjeft01
//systin dd *
PLAN(-----), LIB(-------), PARMS(------)
WHAT WILL U GIVE INSIDE THE BRACKETS...
WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY
I have one ps file in which there are 3 fileds
emp_no,emp_name and leave_app.this ps file information give
the detail of employee which is going to apply for
leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that
means he is going to apply for 1 day leave.and accordingling
the table in db2 will be updated means if he has that no of
leave in his account then he will get dat leave and updated
acc. in table(leave_balance=previous leave present in
table-leave_app).Now i want to check whther the updated
result is correct or not by comparing the two ps file using
IEBCOMPARE or icetool so what is going to be the two ps file
and how its is going to be compare.