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

I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.

Steria,

1566

Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.

1 2908

Difference between file status codes 02 and 22.... since both are for duplicate key detection.

1 3124

what is the use of keep and pass in disp

1 2830

How to create delta file using JCL

CTC,

1 3608

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Danske,

1 3658

Which command can you use to check for the number of records in a physical file?

1315

Difference between array and sub-script ?

HCL,

1656

Extract only those records from a PS file which are having word 'TEXT' in the records using COBOL? The word TEXT is not present in a particular position in all the records.

RBS,

2 3837

Write a query to extract first 5 characters of a name in the column Stud_Name?

RBS,

1 2670

interview type questions like basics&deep

TetraSoft,

1438

mainframe questions like basic&depth

TetraSoft,

1619

by using cond parameter maximum 8 cond can be coded in single cond means ?explain

1457

which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad

1503

Read a flat file and write last but one (I have n records in a file I have to write n-1th) record in another flat file. Could you please provide me the code in COBOL?

1 2633

Un-Answered Questions { IBM MainFrame }

Explain the jcl exec statement?

1146

What's The Percentage Free Space ?

1224

How to check sequence on a table in db2?

1056

What methods are available for persisting records in an idms database? Explain.

816

Explain the difference between record occurrence and record type?

2056

There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.

1432

Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?

994

What is an ims database?

1140

what is JCL?

1158

How to compare data between two tables in db2?

1084

What is the syntax for creating a table in the db2 database?

1103

In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

1465

Explain eib?

918

State the uses of syspring, sysin, sort fields, sum fields and dummy.

1088

List the different jcl statements that are not permitted in the procedures?

1080

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