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

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 5715

max number of columns in a db2 table?

6 25306

Can you access the DB2 Directory table using SQL?

3 7800

What is correlation names?

1 4960

What is an alias?

3 6452

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?

3 6718

What is the difference between Where and Having Clause

IBM, iFlex,

7 30801

Which transaction use a command thread ?

1 3908

What is a LIKE table and how is it created?

2 5630

Name some fields from SQLCA.

2 6678

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

Cap Gemini, Tech Mahindra,

3 18512

What are the isolation levels possible ?

3 7208

What is meant by index cardinality?

2 6712

What does the RUNSTATS Utility do?

4 20876

What is the purpose of the QUIESE Utility?

1 5253

Un-Answered Questions { MainFrame }

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

1782

pls send the docs of any telecommunication mainframe project

2208

What is the latest version of ibm db2?

1352

Are you comfortable in cobol or jcl?

1098

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

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

2464

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

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

2157

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

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

1302

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

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

2279

For More Un-Answered { MainFrame } Questions Click Here