MainFrame Interview Questions
Questions Answers Views Company eMail

Comment whether the cursor is closed during commit or not.

648

Define predicate?

618

Explain about cursor stability?

602

List out the buffer pools in db2

605

What is a storage group (stogroup)?

751

Explain dclgen.

702

What is sqlca’s maximum length?

646

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

613

Define declaration generator (dclgen).

648

Define data page.

607

Mention the different locking levels that are available in db2.

616

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

636

Discuss about db2 bind?

650

List out the data types available.

678

Define sqlca.

630


Un-Answered Questions { MainFrame }

How do you eliminate duplicate values in db2?

664


difference between vsam and database tables

618


Is it possible to move the alphanumeric variables to a numeric variable?

621


What is dbid used in adabas?

536


what is kids-rpg?

643






Where is the vsam ksds placed?

534


What is a run unit?

975


what is the right time for using in-line perform?

564


What is the difference between fixed length and variable length records?

506


is there any other way to install s/w in mainframe apart from smp/e system?

2303


define the purpose of the %sst function?

894


Differentiate between cs and rr isolation levels? Where do you specify them?

553


What Does Lokup Does In Tables & Arrays?

702


what is a physical file?

970


Can you define a gdg?

522