IBM MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

COBOL (1072)
JCL (1031)
CICS (755)
DB2 (1122)

IMS (143)
IDMS (107)
Natural (81)
ADABAS (26)

REXX (60)
Assembler (68)
CLIST (6)
QMF (32)

MVS (25)
OS390 (10)
OS 2 (7)
VSAM (319)

IBM MainFrame Interview Questions

Questions Answers Views Company eMail

How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)

HCL,

1 3333

In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

1 2050

What does LA R3,R3 ?

Amdocs,

1 3332

What is SQL Code -904 and -903 in DB2 And how to handle it?

IBM,

1 7437

Why we should use cursor ?

3 4398

I know my query will return more than one row but I don't want cursor what should I do?

1 3531

How can you get the number of rows impacted by the last executed query?

1 2904

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

JPMorgan Chase,

1 2393

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 3762

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5633

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

Cap Gemini,

1 2624

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

TCS,

1 3298

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

TCS,

1 3294

I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1 1894

How to override loadlib?

Fiserv,

1 2134

Un-Answered Questions { IBM MainFrame }

List the type of locks and explain each of them.

986

what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please

4533

i need a small 3d program using inline and outline.

2279

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1797

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2104

PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS

2464

What is the latest version of ibm db2?

1352

can any body give me any website for getting help on mainframe projectts in banking domain.

2157

Is it rquired any server for Ibm framework? Give me list of Ibm framework & recent version IBm framework?

2309

pls send the docs of any telecommunication mainframe project

2208

Are you comfortable in cobol or jcl?

1099

For More Un-Answered { IBM MainFrame } Questions Click Here