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

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