There 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.
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 .
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 .....
what is unit testing ? on which basis you will write test case ?
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.
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.