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

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 4445

What are column-name qualifiers used?

1 4406

Explain transactions, commits and rollbacks in DB2.

3 8392

How is a typical DB2 batch program executed ?

1 6715

What information is held in SYSIBM.SYSCOPY?

1 5954

What DB2 Catalog column tell you when an index needs table reorganized ?

1 4814

When can an insert of a new primary key value threaten referential integrity?

Mind Tree,

2 7666

what are the max. & min. no. of partitions allowed in a partition tablespace?

IBM,

2 9087

what's the error code for Unique Index Violation?

2 8457

When do you use the IMAGECOPY?

4 8626

What do you mean by NOT NULL? When will you use it?

3 6712

When would you prefer to use VARCHAR?

3 7892

Explain an outer join?

1 5237

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 5960

What is REORG? When is it used?

4 10174

Un-Answered Questions { MainFrame }

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

1782

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

4533

List the type of locks and explain each of them.

985

how can you specify no duplicate key?

1221

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

2279

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.

1797

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

2309

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

2836

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

2417

What is the latest version of ibm db2?

1352

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

1302

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

2464

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

2157

Are you comfortable in cobol or jcl?

1098

pls send the docs of any telecommunication mainframe project

2208

For More Un-Answered { MainFrame } Questions Click Here