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 3194

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 3190

how to create physical file

1 2434

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

1837

How to override loadlib?

Fiserv,

2036

When it is desirable to describe files Internally?

1710

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,

1601

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 2909

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

1 3125

what is the use of keep and pass in disp

1 2831

How to create delta file using JCL

CTC,

1 3612

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?

1318

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

1699

Un-Answered Questions { MainFrame }

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

1103

What is difference between alias and synonym in db2?

1140

how will you find a string using pdm?

1149

How to send a sms to a mobile through mainframe vm’s?

995

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1190

What is the cobol picture clause of the db2 data types date, time, timestamp?

1066

What is qsam? How it is used?

741

What is copy pending status in db2?

1123

Explain how many exceptional condition can be given in a handle condition?

1020

What do you mean by linkage section?

1001

What is the default value(s) for an initialize and what keyword allows for an override of the default?

1211

Why is it required to have a keyed directed retrieval?

1023

Kindly specify the pic clause for the hhmmss type of data fields?

1066

can oorexx run ibm object rexx programs?

1005

Differentiate between the joblib and the steplib statements?

1438

For More Un-Answered { MainFrame } Questions Click Here