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 4803

max number of columns in a db2 table?

6 22925

Can you access the DB2 Directory table using SQL?

3 6411

What is correlation names?

1 3960

What is an alias?

3 4757

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 5141

What is the difference between Where and Having Clause

IBM, iFlex,

7 27572

Which transaction use a command thread ?

1 3086

What is a LIKE table and how is it created?

2 4512

Name some fields from SQLCA.

2 5636

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 16547

What are the isolation levels possible ?

3 5527

What is meant by index cardinality?

2 5585

What does the RUNSTATS Utility do?

4 19063

What is the purpose of the QUIESE Utility?

1 4365


Un-Answered Questions { IBM MainFrame }

Define transient data?

573


What is precompiler in db2?

585


1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

1609


Explain how pa key is different from pf key?

649


in a cobol select statement, can you tell what is the organization for a ksds?

625






What is a lds (linear data set)?

554


How do you round the addition or subtraction of two numbers in assembler?

602


What are the sub parameters for undo command?

560


Explain the advantages of adabas?

580


What is meant by batch dl/i mode?

579


How do I connect my db2 database to ibm?

601


File1 has 100 records and file2 has 200 records I want to copy 50 records which are in both file into file3?

503


Mention one alternative aspect of CICS?

625


What is auto status?

1141


Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.

5057