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

Are views updateable?

1 1261

What is reorg?

1 1267

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

1 1176

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1 1172

What is meant by dclgen?

1 1187

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1 1160

How is a typical db2 batch pgm executed?

1 1237

Differentiate between cs and rr isolation levels? Where do you specify them?

1 1144

Name the various locking levels available?

1 1149

Explain how can you do the explain of a dynamic sql statement?

1 1195

How do you find the maximum value in a column in db2?

1 1172

How do you eliminate duplicate values in db2?

1 1296

How do you concatenate the firstname and lastname from emp table to give a complete name?

1 1149

How do you pull up a query which was previously saved in qmf?

1 1220

When do you specify the isolation level?

1 1092

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

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

4547

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...

2422

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

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

2167

how can you specify no duplicate key?

1229

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

1312

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...

2841

List the type of locks and explain each of them.

986

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

1789

Is it rquired any server for Ibm framework? Give me list of Ibm framework & recent version IBm framework?

2313

Are you comfortable in cobol or jcl?

1106

What is the latest version of ibm db2?

1358

pls send the docs of any telecommunication mainframe project

2214

For More Un-Answered { MainFrame } Questions Click Here