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

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

 1597

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?

Mphasis,

4 7516

How can you display the current date & current time ?

Cap Gemini,

1 4298

How can you display the current date & current time ?

Cap Gemini,

7 10645

Which one allows duplicate values Union or Union All ?

 3 6346

Can you Average the Characters ?

 3 4780

What is DCLGEN ?

 3 7120

what is SPUFI ?

 2 6327

Is Cursor exicutable ?

TetraSoft,

3 6540

Name some fields from SQLCA

 1 5398

What do you need to do before you do EXPLAIN ?

 1 4167

What are the Isolation levels possible ?

 5 6175

what is the soft code for deadlock ?

Logica CMG,

2 5741

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

Logica CMG,

2 5012

what are the SQL codes u freequently got?

Logica CMG,

2 6609

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the information associated with sysibm.syslinks table?

657

Are views updateable?

645

What is a dbrm in db2?

576

How to check table size in db2 sap?

581

What is cursor stability in db2?

811




What is the function of logging in the db2 database?

645

What is dpf in db2?

666

What is the role of the data page in the db2 database?

587

How do I add a column in db2?

591

How can the duplicate values be eliminated from db2 select?

631

What are the rules for db2 programming?

643

What is a db2 schema?

764

What is bufferpool in db2?

580

What is a db2 table?

597

What is the use of with ur in db2?

615

For More Un-Answered { DB2 } Questions Click Here