IBM 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 4812

max number of columns in a db2 table?

6 22944

Can you access the DB2 Directory table using SQL?

3 6432

What is correlation names?

1 3968

What is an alias?

3 4786

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 5150

What is the difference between Where and Having Clause

IBM, iFlex,

7 27621

Which transaction use a command thread ?

1 3101

What is a LIKE table and how is it created?

2 4520

Name some fields from SQLCA.

2 5641

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 16572

What are the isolation levels possible ?

3 5540

What is meant by index cardinality?

2 5593

What does the RUNSTATS Utility do?

4 19099

What is the purpose of the QUIESE Utility?

1 4370


Un-Answered Questions { IBM MainFrame }

List the different components of jcl statement?

698


Explain how do you control cursor positioning?

569


Explain identify whether a call statement is a static or dynamic call?

556


What is the syncpoint command?

599


Can you explain cics transaction gateway?

621






What does a COMMIT statement do?

1032


What does db2 mean?

589


What is check constraint. Explain with example.

650


How do I import data from excel to db2?

617


What is the difference between dbm cfg and db cfg file in db2 ?

1009


List the various advantages of using jcl language?

854


can all users have the privilage to use the sql statement select * (dml)?

644


When are scope terminators compulsory?

593


Discuss about db2 bind?

676


How to find the number of rows in a db2 table?

644