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 :)
Our issue is there seems to be a disconnect, or no link,
between our SELECT statement and our SD. We had
SELECT SORT-FILE and SELECT SORT-FILE
ASSIGN TO SORTWRK. ASSIGN TO SORTWRK1
with SD SORT_FILE
RECORD CONTAINS 7833 CHARACTERS.
In either case, at run time, the system ignored our
SORTWRK# DD statements and allocated 16 sort works with the
SORTWK## naming convention. Any ideas why the system does
not recognize the connection? We do not even need the
SORTWRK DD statements. Thanks
Under the Logical files, when am working on multiple rec
format logical file,
I have joined two pf's using the multiple record format
logical file concept, but when i run queried the LF only the
first mentioned pf records are reflecting and I am not able
to see any of the field records specified under the second pf.
Kindly let me know whats the reason behind this.
Below is the str of LF.,
R rec PFILE(LOGICAA)
R rec1 PFILE(LOGICAA1)
K CUSTNO .....
My Question is
1. How to cound no. of records in JCL. Please explain with
2. How to execute only odd steps in JCL?
I know EDIT TYPE = Inculde, Step Name = 1,3,5 and
COND code for all even step.
Anyone knows other than this.
if i am having a cics,vsam and db2 programs with each
functions and i want that each function on screen?
Mainframe project required
Postby mache123 » Thu Jan 29, 2009 9:10 pm
I want to know about some real time projects.If any one have
any Mainframes project, please provide me documentation of
it Or else give me the link where can I find that Mainframes
projects with Documentation...... or suggest me any
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