Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  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

 1365

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 6673

How can you display the current date & current time ?

Cap Gemini,

1 3918

How can you display the current date & current time ?

Cap Gemini,

7 9749

Which one allows duplicate values Union or Union All ?

 3 5797

Can you Average the Characters ?

 3 4252

What is DCLGEN ?

 3 6501

what is SPUFI ?

 2 5910

Is Cursor exicutable ?

TetraSoft,

3 5848

Name some fields from SQLCA

 1 5069

What do you need to do before you do EXPLAIN ?

 1 3836

What are the Isolation levels possible ?

 5 5575

what is the soft code for deadlock ?

Logica CMG,

2 5190

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 4576

what are the SQL codes u freequently got?

Logica CMG,

2 6153

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is table space in db2?

430

What is host variable?

427

What are host variables in db2?

421

How to test SQL -911 error while developing COB-DB2 program

6229

What is the physical storage length of time data type?

468




What are packages in db2?

429

How will you return the number of records in table?

373

What is schema in db2?

415

Is db2 a mainframe?

436

Why cursor is used in db2?

410

What is a db2 package?

430

What is dclgen (declaration generator)?

431

What is syscat in db2?

400

What action db2 takes when a program aborts in the middle of a transaction?

499

How do we specify index to include or not during bind process.

1541

For More Un-Answered { DB2 } Questions Click Here