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

What are some uses of the evaluate statement?

953

What is the mainframe testing?

984

Explore the syntax of the evaluate statement?

958

How can you quickly find out the # of rows updated after an update statement?

1049

Can there be more than one cursor open for any program?

1169

What are the 2 sqlcodes that are returned?

1190

Where do you specify them?

1283

When the like statement is used?

1222

How to retrieve rows from a db2 table in embedded sql?

1393

Are views updateable?

1163

What is reorg?

1162

How can you find out the # of rows updated after an update statement?

1116

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

What is meant by dclgen?

1112

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

Un-Answered Questions { IBM MainFrame }

What is nvl in db2?

1096

What is the biggest disadvantage of using a vsam dataset?

1134

Explain How will you the specification of database file?

907

Explain the data storage?

1006

Explain the address converter?

1011

suppose if you added a coloumn to db2 table, How would it be the Impact analysis?

2062

What do you mean by hierarchical database?

1203

Define the term transaction routing?

1173

Explain how to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?

1131

how to pass the parameters from jcl to assembler pgm?

1109

What is meant by idd in idms?

938

What is a plan and package in db2?

1104

What is the difference between general testing and mainframe testing?

1112

Mention data types used in db2 ?

1162

Explain the difference between the into and the set option in the exec cics receive map command?

1123

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