1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

Explain correlated sub-queries.

 581

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

 623

What are the uses of db2 optimizer?

 809

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?

 571

What is the information associated with sysibm.syslinks table?

 647

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

 620

What is the purpose of using commit?

 607

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?

 654

Define db2.

 658

Highlight all the advantages that are attached to a package.

 617

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?

 615

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is an instance database?

589

What is bufferpool in db2?

568

What is db2 catalog database?

572

What is the use of reorg in db2?

593

What is the use of with ur in db2?

607




Explain the contents that are a part of dclgen.

649

How to find schema of a table in db2?

563

How do you select a row using indexes in db2?

633

What is deadlock in db2?

572

What is meant by dclgen?

613

Can you tell me how can you find out the # of rows updated after an update statement?

602

Discuss about db2 bind?

659

What is runstats db2?

576

What is the latest version of ibm db2?

727

What is a db2 cursor?

615

For More Un-Answered { DB2 } Questions Click Here