Interested to Buy Any Domain ? << Click Here >> for more details...
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 8069Suppose 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 25441Hi 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 14402I 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 6468Thru web page we have triggered the transaction, how can we come to know that whether it has hit the mianframes or not?
2 4768Hi 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 5203How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.
4222There 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 10780Current 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 7311
Define an associator in adabas?
I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?
How can an in-stream dataset be terminated?
What is notcat 2 - gs?
Describe the various parameters utilized in the creation of a gdg?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
what is a jcl?
How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?
What happens when you issue a escape routine in a program? Will there be any compilation /run time erro?
Which mode is used to operate the sequential file?
What is meant by mpp mode?
What is database descriptor?
What is bind in db2?
Is db2 a mainframe?
Explain the purpose of the file status clause in the select statement?
