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 is a typical db2 batch pgm executed?

1 1237

Differentiate between cs and rr isolation levels? Where do you specify them?

1 1134

Name the various locking levels available?

1 1141

Explain how can you do the explain of a dynamic sql statement?

1 1191

How do you find the maximum value in a column in db2?

1 1161

How do you eliminate duplicate values in db2?

1 1280

How do you concatenate the firstname and lastname from emp table to give a complete name?

1 1139

How do you pull up a query which was previously saved in qmf?

1 1212

When do you specify the isolation level?

1 1086

Explain in brief how does db2 determine what lock-size to use?

1 1105

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 2159

How would you find out the total number of rows in a db2 table?

1 1111

Can you tell me how can you find out the # of rows updated after an update statement?

1 1164

What are the contents of dclgen?

1 1169

Why select is not preferred in embedded sql programs?

1 1365

Un-Answered Questions { IBM MainFrame }

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

2157

What is the latest version of ibm db2?

1352

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

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

2464

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

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

2309

Are you comfortable in cobol or jcl?

1098

pls send the docs of any telecommunication mainframe project

2208

List the type of locks and explain each of them.

985

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

2279

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

2103

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