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

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

 1 5309

What is the database descriptor?

 2 13204

What is the syntax required for the creation of a cursor?

 1 8636

What is meant by AUTO COMMIT?

 3 8985

What information is contained in a SYSCOPY entry?

 2 9024

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 18935

What is lock contention?

 1 4838

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

 1 3857

What is COPY PENDING status?

 6 34993

What is IMAGECOPY ?

 6 37293

What are the functions of Bind?

Amdocs, IBM,

2 7287

What is a cursor?

 2 5653

When is the authorization check on DB2 objects done - at BIND time or run time?

 1 12662

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

 2 4374

What can the Locate option of the Repair Utility accomplish?

 2 4750

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is an instance database?

635

How to connect to db2 database from windows command line?

602

What is db2 stogroup?

716

Is schema the same as database?

669

What is runstats and reorg in db2?

833




Explain how can you do the explain of a dynamic sql statement?

701

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

759

What is copy pending status in db2?

677

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7660

What is explain plan in db2?

622

Where can you declare a cursor in a cobol-db2 program?

632

How to create db2 table in mainframe?

678

What is ibm db2 database?

576

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1638

How would the varchar column remarks defined?

677

For More Un-Answered { DB2 } Questions Click Here