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 3304

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 3300

how to create physical file

1 2561

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

1 1905

How to override loadlib?

Fiserv,

1 2143

When it is desirable to describe files Internally?

1 1783

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,

1 1649

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

IBM,

1 1679

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 3010

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

1 3278

what is the use of keep and pass in disp

1 2920

How to create delta file using JCL

CTC,

1 3761

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

Danske,

1 3800

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

1 1372

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

1 1789

Un-Answered Questions { MainFrame }

i need a small 3d program using inline and outline.

2290

PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS

2471

pls send the docs of any telecommunication mainframe project

2214

How to convert a spool file to PDF file in AS400?

1312

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1803

any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1789

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2423

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2111

can any body give me any website for getting help on mainframe projectts in banking domain.

2168

what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please

4548

how can you specify no duplicate key?

1229

Are you comfortable in cobol or jcl?

1107

What is the latest version of ibm db2?

1358

If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2842

List the type of locks and explain each of them.

986

For More Un-Answered { MainFrame } Questions Click Here