MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

TCS,

1 3200

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

TCS,

1 3194

how to create physical file

1 2439

I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1838

How to override loadlib?

Fiserv,

2040

When it is desirable to describe files Internally?

1714

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

How Chain operation copies the record's data to the input buffer for the program?

IBM,

1606

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 2913

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

1 3129

what is the use of keep and pass in disp

1 2834

How to create delta file using JCL

CTC,

1 3616

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

Danske,

1 3664

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

1319

How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz

1701

Un-Answered Questions { MainFrame }

Explain how can return codes be tested before execution of a job step?

1329

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

1049

What is the use of predicate?

1043

what is the purpose of dynslt keyword?

1753

do you use message subfiles? What are the necessary keywords required coding a message subfile?

1133

Explain about record currency?

854

what the purpose of ovrdta, ovrata keywords?

1962

What is file information data structure(infds) in as400?

1477

How and when does the db2 enforces the unique key?

1083

How gdg are concatenated?

1119

How does a cursor work?

988

What are the different rules for performing sort operation?

1224

What is the advantage of defragmentation?

967

State the difference between jes2 and jes3?

1012

What are the parameters that are used in creating a gdg?

1214

For More Un-Answered { MainFrame } Questions Click Here