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 is the command used by TSO users to invoke DB2?

IBM,

2 9534

What is the FREE command?

1 5299

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

1 2921

What is DB2 (IBM Database 2)?

3 5807

What is QUIESCE?

2 13337

what is the name of the default db2 catalog database?

IBM,

3 8703

What are the three DB2 date and time data types and their associated functions?

1 5506

What is the significance of DB2 free space and what parameters control it?

1 5626

Explain the EXPLAIN statement?

1 5076

What is a DBRM, PLAN ?

3 18769

What's the maximum number of characters that a tablename can have?

3 9029

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 16101

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 5024

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2122

Why use RUNSTAT Utility?

Merrill Lynch,

3 24109

Un-Answered Questions { MainFrame }

What is the latest version of ibm db2?

1352

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

1301

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

Are you comfortable in cobol or jcl?

1098

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

2157

how can you specify no duplicate key?

1221

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

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

2279

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

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

2464

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

1782

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

2103

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

pls send the docs of any telecommunication mainframe project

2208

For More Un-Answered { MainFrame } Questions Click Here