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 9415

What is the FREE command?

1 5181

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

2852

What is DB2 (IBM Database 2)?

3 5667

What is QUIESCE?

2 13202

what is the name of the default db2 catalog database?

IBM,

3 8548

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

1 5396

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

1 5475

Explain the EXPLAIN statement?

1 4985

What is a DBRM, PLAN ?

3 18608

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

3 8891

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

CTS, IBM, TCS,

9 15760

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 4932

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?

2064

Why use RUNSTAT Utility?

Merrill Lynch,

3 23931

Un-Answered Questions { MainFrame }

Is it possible to define dd statements as you want?

1115

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

961

In the EIB block of CICS, highlight the names of few of the important fields?

1051

what is the meaning of a (new, catlg, keep) disposition mean?

1023

How to create 1 ddm that fetches 3 adabas files simultaneously?

929

What is the as400 called now?

986

Explain why do we use file-aid for seqential files?

1073

http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?

1109

How many bytes S(8) comp field occupy and its maximum value?

2142

What is the difference between run mode and addressing mode?

1250

How vsam files are read in cics pgms?

1305

What is the connection string to connect to the DB2 Database ?

1128

explain how do you define a gdg in vsam?

1033

What are INPUT PROCEDURE and OUTPUT PROCEDURE?

1300

Explain about set currency?

867

For More Un-Answered { MainFrame } Questions Click Here