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 7519

How can you display the current date & current time ?

Cap Gemini,

1 4300

How can you display the current date & current time ?

Cap Gemini,

7 10656

Which one allows duplicate values Union or Union All ?

 3 6353

Can you Average the Characters ?

 3 4783

What is DCLGEN ?

 3 7125

what is SPUFI ?

 2 6329

Is Cursor exicutable ?

TetraSoft,

3 6553

Name some fields from SQLCA

 1 5400

What do you need to do before you do EXPLAIN ?

 1 4170

What are the Isolation levels possible ?

 5 6179

what is the soft code for deadlock ?

Logica CMG,

2 5745

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 5018

what are the SQL codes u freequently got?

Logica CMG,

2 6613

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the various isolation levels possible?

650

What is reorg and runstats in db2?

696

How do I delete a table in database?

601

Is ibm db2 open source?

589

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1711




What is an instance database?

602

What are packages in db2?

599

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1651

What are the contents of dclgen?

661

Highlight all the advantages that are attached to a package.

629

What is query_cache_limit?

547

Explain db2.

620

Which component is responsible for processing sql statements and selecting access paths?

671

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

716

What happens in bind step in a db2 program?

569

For More Un-Answered { DB2 } Questions Click Here