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?

1234

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

1131

Name the various locking levels available?

1140

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

1186

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

1157

How do you eliminate duplicate values in db2?

1278

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

1136

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

1209

When do you specify the isolation level?

1082

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

1101

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

1 2149

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

1102

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

1157

What are the contents of dclgen?

1167

Why select is not preferred in embedded sql programs?

1361

Un-Answered Questions { IBM MainFrame }

What is a bind in db2?

1112

what is difference bt COND, REGION & TIME parameters at JOB & EXEC. give an exp.

9191

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1150

What is notcat 2 - gs?

1524

how to access the file from prodution from changeman tool and to submit a file to production

7639

Explain Introduction abt Ibm framework

2210

What is bind package and plan in db2?

1116

What is the difference between nvl and coalesce?

1116

Explain the like inverted list?

1002

Does qtp tool support mainframe application testing?

1144

What is db2 plan table?

1115

Can I redefine an x(100) field with a field of x(200)?

1016

Explain the difference between start and xctl?

1131

Name the sections present in data division.

1327

WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99 VALUE 123.45. PROCEDURE DIVISION. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. compiler : IGYGR1080-S A "VALUE" clause literal was not compatible with the data category o subject data item. The "VALUE" clause was discarded. WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99. PROCEDURE DIVISION. MOVE 123.45 TO W-B. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. 2375

1531

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