Ibm Mainframe Placement Papers - Ibm Mainframe Interview Questions and Answers
Q1. How Do We Describe Cataloged Procedure And An Instream Procedure?
Cataloged approaches are invoked thru a specification of the call of the technique over the Exec statement and cataloged at the library of the technique. For verifying a method prior to becoming a catalog manner we are able to use an in-circulation process. Instream processes are much like catalog strategies but there is a small difference at their execution:for executing them there are required to be located between the Job statement and the Exec declaration and that they should be completed with a Pend announcement.
Q2. How Many Sections Are There In Data Division?
6
Q3. Suppose I Have one thousand Rows In A Db2 Table. I Want To Update First a hundred Records, How Do I Do It?
Is there identification column on this table, for example, if there's a column indexnum int(intended begin from 1), you can use the Update Table Set XXX=XXX in which indexnum < a hundred and one
Q4. What Is The Meaning Of Ssrange And Nossrange?
These are options of the compiler for verifying the out of range state for the subscript. The default will be NOSSRANGE and it implies no flagging of run-time errors when the subscript or index is exceeding the permitted range.
Q5. Indicate Which One Of The Following Is Not True About The Set Verb?
The verb may be used to increment one or extra identifiers by way of a nice vital fee.
Q6. What Is The Right Time For Using In-line Perform?
The right time is while the carry out body isn't always used. If it's far a form of code that has standard me, being utilized in several places in the application, the code need to be met in a exceptional para and not use in-line carry out, however perform paraname as a substitute.
Q7. Which Of The Following Is True About The File Which Is Referenced In A Delete Statement?
Opened I/O mode
Q8. In An Evaluate Statement, Can I Give A Complex Condition On A When Clause?
Yes
Q9. What Is The Meaning, The Advantages And Which Are The Types Of Evaluate Statement?
Evaluate statement is a distinct manner for the neste IF statements and it works via deciding on from a processing moves listing. To replace IF we will use When to discover if an action can be taken. Like IF , When manipulate is going from examine to the following declaration on the software. The styles of compare announcement are trues and variable-name.
Q10. How Can We Describe Comp Sync?
COMP SYNC aligns an item to the herbal obstacles, it will likely be synchronized proper and left. If we use binary objects that are found on the obstacles of phrases in memory, these ones have a more speedy deal with decision. The length of word from mainframe reminiscence is 4 bytes. So each word has to start from an address that is divisible by means of four. When the primary variable is x(three) and the subsequent one is s9(four) comp if the Sync clause is not special, the second one variable will begin from byte @When Sync is unique the beginning address will be four; this extra fast, although we may additionally note a touch waste of memory.
Q11. What Is The Meaning Of A (new, Catlg, Keep) Disposition Mean?
The which means is that we have a sparkling datasheet and it must be allotted, the datasheet have to be CTLG if all went proper however to KEEP and not CTLG the datasheet while all is abended.
Q12. What Sorting Order Does Search All Have?
The sorting order of SEARCH ALL could be Descending or Ascending, the initial cost is Ascending. When we need to interchange to Descending we ought to provide the Descending Key clause inside the time we define the array which will be taken care of; the table must be loaded within the order said.
Q13. How Do We Describe Static Call And Dynamic Call?
The difference among Static and Dynamic Call is that the first has the invoking application name tough coded into the call assertion at the same time as the second one has it in storage in an identifier. Also inside the case of Static the invoking application is hyperlink edited with the invoked subroutine and in the case of Dynamic Callwe will have a extraordinary module for each: the main application and the subroutine. IF we don’t use Initial or make a Cancel whilst we invoke the statically referred to as subroutine then it will no longer be discovered inside the default country; dynamically called habitual could be forever in the default nation.
Q14. What Is The Meaning Of Notcat 2?
NOTCAT 2 is a MVS message that indicates if or extra entries of the equal catalog exist. If an access is already there the catalog could send us an mistakes message. The difficulty can be repaired via uncataloging or deleting the primary records set and we should discover that extent which includes the new statistics set and we must catalog it.
Q15. Can You Rewrite A Record In An Esds File? Can You Delete A Record From It?
Can rewrite (file length have to be equal), however now not delete.
Q16. While Creating A Table, By Mistake You Have Given Size Of One Field As
If table is empty then we regulate this column to any duration, however if a few statistics get inserted into the desk then we also can decrease the column length up to biggest facts size to be had in that unique column.
Q17. How Can We Repair A Soc-7 Error?
The fundamental issue to do is repairing the tricky data, normally the purpose for issues with SOC-7 is a numeric item that is un-initialized, that is the number one problem. Some of the setups supply us dumps for run-time abends, this may additionally be made via invoking OS offerings or subroutines thru the assembly language. The dumps are useful as thei give us the remaining training’s offset wherein the abend took place. The output XREF listing of the compilation must be verifiedfor obtaining the road range and the verb of this offset’s source code. After that the worm can be discovered in the source code. For shooting the runtime dumps, we should outline datasets like for example Sysabout in JCL. When these techniques aren't running we need to find the error supply with judgement and Display. If the setup has debugging utilities, we ought to make use of them.
Q18. What Is Difference B/w File-useful resource Tool And File-useful resource Utility?
File-aid tool is online device (application) used for processing files the usage of on line monitors. File-aid application is used in jcl for processing documents in batch.
Q19. What Is Use Of Linkage Section?
Linkage phase is used to accept facts from outdoor this system.Both it is parm a part of Jcl or Call from another applications,they bypass facts into known as program thru linkage segment most effective.
Q20. What Difference Exists Between Control Area And Control Interval?
A Control Area is a hard and fast of Control Intervals and it works in the course of allocation. The size of the Control Area relies upon at the form of allocation (cyl, tracks, facts) and ots most reaches 1 cylinder. The Control Interval is some thing like a block for QSAM documents, its size is ranged between 512 bytes and 32 kilobytes, generally 2 or four kilobytes. If the Control Interval is larger the performance will also increase when it comes to sequential processing.
Q21. How To Handle -911 (deadlock) Error In A Db2 Program So That The Program Will Never Abend?
Dead lock timeout blunders takes place within the following case: If or extra packages obtained extraordinary lock on the data,which can be wanted for other packages without that information which cannot continue similarly.
Solution: You can roll returned present day unit of labor for one of the programs after preset time c program languageperiod for deadlocks and terminate that software.
Q22. Suppose I Have Two Tables A And B. Both Tables Are Connected With Ssn Number As Foreign Key. I Want To Retrieve A Column Data From B Table. How Will You Write A Query?
One can use Inner Join to get facts from tables
Q23. Which Is More Efficient, Level seventy seven Or 01?
01
Q24. Can The Occurs Clause Be At The 01 Level?
No
Q25. How Is Sign Stored In A Comp Field ?
In the maximum giant bit. Bit is ON if -ve, OFF if +ve
Q26. What Are The Parameter We Cannot Use In Procedure? How Many Instream We Can Write In Single Jcl? Can We Call Instream To Catalog And Catalog To Instream?
Sysin dd * we can not use in manner,15 instream proc we are able to code.We will call instream to catalog.But we can not call catalog to instream
Q27. What Optimum Values Can We Find For Freespace, Ci Etc?
The size of CI has to rely upon the duration of the record and the processing type. The regular value is four kilobytes but while the period of the report is larger than 1 kilobyte we have to pick out 6 kilobytes or eight kilobytes. The ordinary values for FREESPACE are (20 20), when many insertions are made it have to be bigger.
Q28. We Have An Output Dataset In Job With Disp Parameter As Shr. Can We Write Data In That File Dataset?
We can't write when disp is proportion.
Q29. Suppose Oza017.Myorg.Emp Has one hundred Records ,oza018.Myorg.Group of workers Has 2 hundred Records But 50 Are The Common Records In Both Files Copy All The Common Records Into Oza017.Myorg.Xyz Dataset?
IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.
Q30. How Can We Increment Subscript And Index?
SUBSCRIPT:
CAN BE INCREMENT OR DECREMENT USING ARITHMETIC OPERATIONS
INDEX:
CAN BE INCREMENT OR DECREMENT USING SET VERB
Q31. How Are Start And Xctl Different?
Start is used for the beginning of latest tractions and then the XCTL takes the operations in addition , trferring the control to a extraordinary application but with an identical traction ID.
Q32. What Is Label Record Is Standard Or Omitted In File Description Of Data Division?
Label record is standard me it's going to use disk files. But tape files will have trendy label too. If the label record is left out it must be a the tape record with none begin and cease blocks at the tape.
Q33. How Could You Write A Program In A Structured Format?
No go to's
Q34. Accept Ws-date From Date Will Return The Current Date?
IN YYYYMMDD FORMAT
Q35. Can We Describe The Results Of Opening For Input Empty Vsam Files In A Cobol Program?
If the VSAM record didn’t have a file earlier than it will likely be visible as unavailable and if we try to open it the operation will now not prevail. Empty files can simply be opened for output, case in which a dummy document could be written by means of COBOL and the report may be erased.
Q36. How Can We Define A Gdg?
GDG me GenerationDataGroup, for outlining it we can write the command DEFINE GENERATION DATA GROUP. In the IDCAMS step, a one-of-a-kind information set has to be described and its DCB parameters will be used at the time whilst new generations are made. This is what we name a model dataset, whose ds name must be just like the one of the GDG.
Q37. How Would Find Total Records In Files Using Sequential?
We can increment the matter for every reading of document in a record.
Read record
be counted = count + 1
At give up
display count number
Q38. How To Get The Last Record In Vsam File In Cluster? And How Can U Get The Ksds File Records Into Ur Cobol Program?
Move excessive values to the important thing of the VSAM report and the issue Readnext record command. Then give Readprev command. This will study the ultimate report. In VSAM, there's one command HURBA, Using that we will read the final report, If you want to recognise more about visit IBM RED BOOKS. You gets the answer. By using the use of the HURBA we will get the max statistics by way of the usage of the CKD depend key statistics we are able to get the ultimate report
Q39. Execution Of A Subordinate Module Is Caused By The Use Of The Cobol Verbs ------------in The Superior Module
Perform
Q40. A Word In The Computer Memory Is Identified By_________
word period
Q41. What Is The Other Verb For Release And Write ?
Rewrite and Read
Q42. What Is The Role Of The Is Numeric Clause?
IS NUMERIC might be to be had for alphanumeric, packed decimal, unsigned numeric and signed numeric gadgets. When an item is fabricated from 0 to 9 the price returned via IS NUMERIC is True, if the object is signed then it may have zero to nine but also + and -.
