Company name: BOA COBOL 1. Static call VS Dynamic call 2. How can you tell a CALL is static or dynamic just y loo!in" at t#e code$ %. &' a COBBA( pro"ram pro"ram is callin" COBBA(DB pro"ram) #ow many plans would e t#ere$ *. +#at are t#e ways you can pass ,alues to ot#er pro"rams$ -. +#at are t#e ways you can "et ,ales to a pro"ram$ . +#at is t#e use o' /0LAC&3 clause in COBOL pro"ram a"ainst copyoo!s$ copyoo!s$ DB2 1. Catalo" tales$ 2. LA4(ABL0 5 w#at are t#e ,alues you will loo! in t#e tale 'or optimi6ation$ %. D0AD5LOC7$ *. &' a pro"ram is runnin" 'or a lon" time w#ic# ran ,ery minimal time yesterday) w#at are all could e t#e reason$ -. S8L codes: 9*) 9%) 9*) ;11) ;%) -% . +#y cursor$ <. & !now my =uery will return more t#an one row ut & don>t want cursor w#at s#ould & do$ 55 pro,ide ?0(CH ?&/S( /O+ OL@ ;. +#at is %-$ LL indicator not #andled properly. 9. +#at are t#e ways to #andle LL indicator$ 1. DB2 utilities /0O/3) /S(A( 11. (#ere is a student tale w#ere a student can #a,e more sujects and mar!s secured in t#at suject. ow want t#e complete details o' student w#o appeared 'or more t#an % sujects. 12. &O) &O ALL w#ic# will "i,e a distinct result$ 555 &O 1%. +#at is t#e di''erence etween 3/O B@ and O/D0/ B@$ 1*. CO&( and /OLLBAC7 555 #ow will you secure opened cursor 'rom CO&($ +ill /OLLBAC7 close all t#e opened cursor$ 1-. S@S&B tales$ 1. How can you "et t#e numer o' rows impacted y t#e last eecuted =uery$ 5 S8L0//D %E 1<. &solation le,els$ CS) //) / 1;. & am compilin" my DB2 wit# CS will it loc! t#e tale t#ou"# & use simple select on a tale$ 19. +#at are cluster and inde$ Company name : HCL 1. How will you uild an internal array in COBOL pro"ram 555 OCC/S clause 2. How will you create a dynamic internal tale$ 555 usin" D00D&3 D00D&3 O clause. %. Do we need to declare t#e dependin" on clause ,ariale in +S$ 55 O *. Dynamic and Static calls$ How will you identi'y just y loo!in" at t#e pro"ram$ -. How will you pass ,alues to t#e ot#er pro"rams$ Via Lin!a"e section) 8) ?iles) (D8) (S8) C#annels F Containers . +#y we s#ould use (S8) we can use (D8 instead ri"#t$ <. +#at is Binary searc#$ +#at is t#e de'ault orderin" o' Binary searc# 55 ASC. ;. +#at is eecutale eecutale LA or ac!a"e$ 9. +#at is Suscript and &nde$ Company ame 5 C(S 1. 2. %. *.
Static VS Dynamic calls Suscript VS &D0G 55 w#ic# is etter$ +#y it is etter$ Searc# VS Searc# all$ +#at is CO and CO%$ How muc# space will 9*E CO occupy$
-. +#at are isolation le,els$ +#at eac# will do$ . +#at are cursors$ +#y we need cursors$ <. 0plain a simple pro"ram w#ic# in,ol,es DB2 li!e #ow will you declare cursor) 'etc#) close etc. ;. 0plain DB2 pro"ram compilation process. 9. 0plain C&CS5DB2 pro"ram compilation process. 1. 8uestions on /ede'ine li!e can +S5A G1E can e rede'ined y +S5B G2E wise ,ersa$ 11. Di''erent 'ile open OD0S and t#eir purpose$ 5 &() O(() &5O) 0G(0D. 12. ?ew DB2 S8LCOD0s ;11) -%) ;% li!e most 're=uent. 1%. Later & was as!ed to write 'ew =ueries y "i,en 'ew sample tales 55 w#ic# in,ol,ed O&S) S IE) 3roup y etc.) 1*. +#at does BLOC7 S&J0 &S J0/O means w#ile de'inin" t#e 'ile in COBOL: pro"ram$ Company name 5 CSC DB2 S8L codes 5-1 to 5-*) 59*) 5911) 5;%) 51;) 51;1) 5%-) 52-) 5922 etc ull indicator 5 #ow will you #andle it$ +#at are t#e possile ,alues returned to null5indicator5,ar$ 52) 51) DB2 Load and unload utilities. Aout 0plain$ How will you determine cost o' an =uery.$ +#ere it will e a,ailale$ Aout COBBA(DB pro"ram compilation process. Bind options$ &solation le,els 5 CS // / /S.. aout eac#. +#ic# is eecutale p!" or plan$ How will you copy a entire tale in one re"ion to anot#er tale w#ic# is #a,in" two more additional columns.$ ortioned tales$
COBOL &nternal tale Searc# and searc# all +#at are t#e c#an"es need to e done w#ile you c#an"in" a S0/CH clause y S0A/CH ALL clause 0/?O/ types Strin" unstrin" inspect How will you "et t#e system date in COBOL p"m$ and #ow will you "et t#e date o' 1 days a'ter today in COBOL not usin" DB2E$ 0,aluate and &' end5i' 5 some situation and answers ?ile or"ani6ations and access modes 'or VSA 'iles CL VSA utility 5 &DCAS Di'' etween /epro and SO/(5copy$ +#at are t#e parameters used w#ile creatin" 3D3) 7SDS) //DS) 0SDS 3D3 5 =uestions li!e 5 'ile created in step one and #ow it will e re'erred in net step. (#is jo aends a'ter step1) t#en w#at are t#e c#an"es need to e done w#ile re5runnin"K c#an"es needed$ nderstandin"s on CLL&B) OBL&B and S(0L&B How will you c#ec! a 'ile is empty and stop processin" t#e net steps. +#at is COD0V0) CODOL@ How many DD statement in a step$ How many steps in a /OC$ Aout 0S%) 0S2 C&CS
+#at is D?HCOA/0A +#at is t#e return code w#en a 'ile open error occurs in C&CS +#at are t#e C&CS aends t#at you are aware o'$ 44444444444444444 3uru:5E @ou>re ne,er 'ully dressed wit#out a smile
HCL Technologies offers world class technology solutions for the emerging network centric world. It provides a range of technology and software engineering services including Technology Development Services, Software ngineering Services, !pplication ngineering Services, "etworking Services . These services are predicated on a rich technology heritage. #perience with the development and application of technologies like Internet and $Commerce, m%edded software, "etworking and telecom protocols, &LSI design etc. Skills on a wide variety of computing platforms from 'pen Systems to nterprise Servers %ased on mainframes e#pertise, o%(ect oriented and legacy system architecture, methodologies in addition to distinguished )*D %ackground uni+uely positions us as a preferred provider of technology and software engineering services in the emerging network centric world. HCL Technologies has esta%lished dedicated offshore software factories with clients such as ankers Trust -!ustralia, Le#is "e#is -/S , South ern California dison -/S, ! "etworking 0a(or -/S HCL Technologies operates through 12 offices in 34 countries in /nited States, urope, 5apan, !sia 6acific The company employs 7788 IT professionals worldwide. HCL Technologies holds 3889 stake in Intelicent -former HCL 5ames 0artin Inc., a /S %ased methodology consulting led Services Company. The company also has a 3889 su%sidiary in India, HCL Comnet Systems and Services Ltd, which provides networking services.
Real time Mainframe interview Questions and Answers : 1.What is DRDA ? DRDA stands for Distributed Relational Database Architecture. DRDA is a connection protocol for relational database processing which !M and vendor databases use. t consists of rules for communication between a remote relational D!M" and the application. #. $%plain the use of the W&$R$? 'he (W&$R$) clause isolates an element or row whenever it is used with a relational statement. *. &ow can a +,$ table be created? t can be made b- the use of the +,$ parameter in the statement R$A'$. 'hese tables are generall- re/uired for testing the production environment.
0. What is the need of running runstats in the test environment? t is for clearing the default values from the catalog columns. !ecause if the columns have default values then the result might not be an e%pected one. 2. What is the need of a secondar- inde% in M"? t is a substitute path into an- M" database. t can be used as a file to ac/uire re/uired data. 3. $%plain foreign 4e-s? 5oreign 4e-s are properties of a particular table having matching entries to a primar- 4e- in some another table. 'his results in the formation of a relation between the two tables. 6. Write about the selfreferencing constraint? t limits the changes that can be made to the primar- 4e- from a foreign 4e-. 5or this purpose7 the foreign 4e- has to define a D$+$'$ A"AD$ rule. 8. What does a deadloc4 mean in D!#? When two independent processes contend for the same resource or the resources reserved b- one another7 it is called a deadloc4. 911 and 91* are the "Q+code for a deadloc4. 9. What is the function of D!'+? t is used to access M" files for " 'ransactions and it is an address space. "!s7 D!Ds7 M" files and A!s are fi%ed into D!'+ for file access. ;ow if an M" call is generated b- a " program the processing gets transferred to D!'+ to be carried7 and the result is sent as repl-. 1<. &ow are '=$ 1 and '=$ # inde%es different? '=$ # inde% is available for D!#>0. n this t-pe7 the data pages get loc4ed7 but the inde% pages are not loc4ed. 'herefore7 '=$ # inde% are faster. 11. What are the different t-pes of 'able spaces? 'here are three table spaces7 namel-: "imple "egmented artitioned 1#. Write the difference between &DAM and &DAM databases? &DAM has a separate inde% file which is based on the root segment. 'his file has information regarding the pointer that mar4s the position of the data. n the other hand7 &DAM file does not have separate inde% file7 but the 4e- field of ever- record is passed through a randomi@er which places the record to a particular position in the database. 1*. $%plain referential integrit-? t is the rule that states that consistenc- needs to be conserved between the foreign and primar- 4e-s. 'his means that each foreign 4e- entr- needs to have a fitting primar- 4e- entr-. 10. &ow are composite and multiple inde%es different? Multiple inde% are two inde%es7 one each for a column of the same table. omposite inde% is onl- one inde%7 which consists of combined values of # columns of a table. 12. What is the advantage in Denormali@ing tables in D!#? t lowers the re/uirement for e%ecuting intensive relational oins. t also cuts the number of re/uired foreign 4e-s.
13. $%plain Database Descriptor in brief? D!D7 short for Database Descriptor7 restricts access to the database when obects get altered7 created or dropped. 16. "tate the ma%imum value up to which volumes can be inserted to an "'BRC? >olumes can be inserted up to 1**. racticall- though7 onl- *0 volumes7 when added to an "'BRC7 becomes hard to manage and monitor. 18. $%plain deleteconnected tables? 'ables7 which are related through a foreign 4e-7 are 4nown as deleteconnected tables. 'his is because whenever an- entr- in the primar- 4e- is deleted7 it affects the values in the foreign 4e- table too. 19. $%plain loc4 contention? 'he D!D onl- allows entr- to one obect at a particular time. +oc4 contention is said to happen when more than one obect see4s permission for e%ecution simultaneousl-. #<. What is "C5? "C5 is the abbreviated form of "Q+ rocessing Csing 5ile nput. t is a menudriven tool which the developers use to ma4e obects in the database. #1. What is an alias? t is a substitute to a s-non-m. Aliases are developed for distributed environments so as to avoid the use of location /ualifier of a view or table. t is not dropped when the table gets deleted. ##. What is the place for >"AM ,"D"? t is the !"D". #*. ;ame and e%plain the t-pe of loc4s? 'here are three t-pes of loc47 namel-: "hared 'his t-pe of loc4 permits two or more programs to read from the loc4ed space but does not allow them to change it. Cpdate 'his loc4 is more lenient. t permits the program to read and change the loc4ed space. $%clusive 'his loc4 restricts all users from accessing the loc4ed space. #0. $%plain isolation level? solation level is the degree to which the activation group in focus is isolated from the activation groups e%ecuting at the same time. #2. What is ;'A'#? t is an M>" message that indicates the presence of a duplicate catalogue in the database. 'his problem can be fi%ed b- removing one of the entries and then adding a new one. #3. What will happen if both "'$+! and E!+! are specified? E!+! is a Data Definition statement. t determines the location of the program7which called the $F$ statement. E!+! applies to all steps present in that whole ob. t is not possible to use it for catalogued procedures. "'$+! is ver- similar E!+!. t determines the dataset in which the program e%ists. t applies onl- to one step and not the entire ob. "'$+! can be used at an- position in the ob step and can also be used for catalogued procedures. n a situation when both "'$+! and E!+! are specified7 E!+! will be ignored b- the s-stem.
#6. "tate the difference between E$"# and E$"*? n E$"*7 the allocation of data sets for the steps ta4es place even before the ob is scheduled for e%ecution. While in E$"#7 this allocation ta4es place ust before the e%ecution of each step. #8. "tate all the 5ile $; modes? 'he four 5ile pen methods are: ;C' C'C' $F'$;D #9. s the order of the W&$; clause significant in an $>A+CA'$ statement? =es7 the order is significant as the evaluation ta4es place in the top to bottom manner and7 therefore7 the order has a large impact in the determination of results. *<. When are scope terminators compulsor-? 'he- are compulsor- for $>A+CA'$ statements and inline $R5RM". "cope terminators are alwa-s declared e%plicitl- to improve readabilit-. *1. What is lin4age section? t is a part of a program that is being called and maps to data items in the programGs HcallingI wor4ing storage. +in4age "ections is where shared items are declared and defined. *#. &ow is ;$F' "$;'$;$ and ;';C$ different? 'he ;$F' "$;'$;$ hands the flow of control to the statement that follows the ne%t period. n the other hand7 ;';C$ hands the flow of control to the ne%t statement after the scope terminator. **. What is the need to code MM'" in batch programs? MM' statements are used to release loc4s which are re/uired for that unit of wor47 and then permit a new unit of wor4. n other words7 if MM'" are not coded in the program and the program has been sent for e%ecution7 then while processing7 in place of ust going bac4 to a few inserts since the nearest commit7 the program has to go bac4 to the inserts which were made during the entire run of the program. 'his e%tra process ta4es around twice or thrice the time ta4en normall-. *0. &ow is data retrieved from multiple tables using a single "Q+ statement? Data can be retrieved from multiple tables b- using oins7 nested selects and unions. *2. Write about a JviewG in brief? t is a virtual table that is made using data from base tables and other views. 'his table is not stored separatel-. *3. What parameters are used to control the free space in D!#? 5ree space permits the addition of new rows.'here are two parameters7 which are used to control the free space in D!#7 the- are: '5R$$ t defines the free space percentage that will be present in each page. 5R$$AB$ t specifies the number of pages to be loaded before leaving a page empt-.
*6. What is the function of CRR$;'DA'A option in bind? t allows bloc4 fetch when selecting rows in a table. t is set to ; b- default from D!#>0. "o it is important to change CRR$;'DA'A H=$"I7 in the bind cards7 to ; in D!#>* K earlier7 as =$" is the default value for them. *8. &ow can record loc4ing be achieved in those D!# versions which do not support it? t can be done b- setting the record lengthGs si@e to more than half of the pageGs si@e. *9. "tate the ma%imum number of tables that can be oined? 'he ma%imum numbers of tables that can be oined are fifteen. 0<. $%plain inde% cardinalit-? nde% cardinalit- is the number of discrete entries in a column. n D!#7 a utilit- RC;"'A'" e%amines the column value redundanc- to find if an inde% scan or tablespace is re/uired for searching of data. 01. Define clustered inde%? A clustered inde% is the one in which columns are maintained in the same se/uence as the rows until there is still free space in the memor-. D!# then processes the table in the given order e%peditiousl-. 0#. ;ame the loc4able units in D!#? D!# implements loc4ing on four t-pes of units: ages nde%es sub page 'ables 'able space 0*. What is the function of the verb ;'A+L$? 'his verb sets Alphanumeric7 alphabetic and alphanumeric field items to ((H"paceI and ;umeric and ;umeric edited field items to (<) HLeroI. 'he ;'A+L$ verb leaves 5++$R items unchanged. 00. What is the importance of MM; Attribute? ts functions are utili@ed in nested !+ programs. f MM; attribute will not be specified7 the nested programs will find it impossible to access the program. An e%ample of MM; program is gmname. 02. What will be the result if ; "L$ $RRR phrase is declared? When the condition is true7 the code written in the (; "L$ $RRR) phrase is performed. During this process7 the content of the destination field does not change. f this phrase is not mentioned7 then the statement is e%ecuted with truncation. M>$ statement does not support the ; "L$ $RRR phrase. 03. an records be accessed randoml- in $"D"? =es7 records can be accessed randoml-. t can be done b- reference of Relative !-te Address HR!AI. &owever7 it is not possible to delete records. 06. Wh- is free space left in ,"D" Dataset? While allocating ,"D" Datasets7 free space is declared at regular intervals at the time of initial loading. 'his is done because this free space is utili@ed for 4eeping the data arranged in se/uence ph-sicall-7 even though inserted randoml-.
08. Write in brief about clusters? t is a combination consisting of the se/uence set7 inde% and data portions in the Data set. 'he cluster has the program access given to it b- the perating "-stem7 and this allows access to be granted to all parts of the Dataset at the same time. 09. $%plain path? t is a file that ma4es accessing a file b- alternate inde% possible. 'he path defines a relation between the base cluster and the AF. ( http://interviewquestionsanswerspdf.com/2014/03/jmsinterviewquestionsandanswers/ ) 50 !"# $%&! '%' %nterview uestions and "nswers ( http://interviewquestionsanswerspdf.com/2014/03/cicsinterviewquestionsandanswers/ ) →
2<. What is the function of $!B$;$R? $!B$;$R helps in cop-ing one "AM 5ile to some other "ource. t is also used to perform simple data reformatting through the suppl- of control cards via "=";.
