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,

1103

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 2110

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

1 2359

what is the use of keep and pass in disp

1 2094

How to create delta file using JCL

CTC,

1 2648

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

Danske,

1 2903

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

993

Difference between array and sub-script ?

HCL,

1147

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 2707

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

RBS,

1 1915

interview type questions like basics&deep

TetraSoft,

936

mainframe questions like basic&depth

TetraSoft,

1010

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

965

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

1011

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 1840


Un-Answered Questions { IBM MainFrame }

What is meant by MDT? Furthermore, comment on FRSET and FSET ?

654


Explain difference between read work file 1 and read work file once? Why we are using work file once?

547


What is RRange and ARange?

1649


What is the eib?

579


What is the role of the data page in the db2 database?

578






Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?

697


What is the use of symbol // in jcl?

911


What is the meaning of the eibaid field?

517


HOw can I get the negative sign while deduct high value from low value

1776


Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!

1480


Explain foreign keys?

547


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1698


what are the secirity tools in mainframe? and let me know about the other tools and the uses of thst immediatly................

1992


What are db2 objects?

630


Explain in DD statement what is the use of DCB parameter?

641