MainFrame Interview Questions
Questions Answers Views Company eMail

Mention the location where the output received from explain statement is stored.

622

What are the uses of db2 optimizer?

807

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598

Before you give the explain statement, what are the prerogatives?

570

What is the information associated with sysibm.syslinks table?

646

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

618

What is the purpose of using commit?

606

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694

What is meant by explain?

652

Define db2.

656

Highlight all the advantages that are attached to a package.

615

What is release/acquire in bind?

641

Mention some fields that are a part of sqlca.

590

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

613

Explain the contents that are a part of dclgen.

649


Un-Answered Questions { MainFrame }

Define dynamic processing?

540


Describe major components of db2?

632


what are necessary keywords to code message subfile?

1003


How do I delete a table in database?

590


What is a dbrm in db2?

568






What are the uses of db2 optimizer?

807


How do you get parameter from JCL to PL1?

2005


Discuss about db2 bind?

658


What is file information data structure(infds) in as400?

961


under given circumstances, my cgi should link to another site. How to implement this?

568


which are the member types which seu supports?

797


Define the term function request shipping?

565


How do you define an altindx?

556


What is the pic clause for the hhmmss type of data fields?

498


Can you define spufi?

522