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

1566

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 7375

How can you display the current date & current time ?

Cap Gemini,

1 4238

How can you display the current date & current time ?

Cap Gemini,

7 10557

Which one allows duplicate values Union or Union All ?

3 6268

Can you Average the Characters ?

3 4696

What is DCLGEN ?

3 7037

what is SPUFI ?

2 6260

Is Cursor exicutable ?

TetraSoft,

3 6441

Name some fields from SQLCA

1 5364

What do you need to do before you do EXPLAIN ?

1 4126

What are the Isolation levels possible ?

5 6125

what is the soft code for deadlock ?

Logica CMG,

2 5669

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 4946

what are the SQL codes u freequently got?

Logica CMG,

2 6549


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is host variable in db2 cobol?

576


What are union and union all?

519


What do you mean by rollback?

550


What is db2 bind?

614


How do I delete a table in database?

577






What is data manager?

584


What does runstats do in db2?

586


What is db2 purescale?

522


List out the data types available.

678


what is the role of the cursor in db2?

623


Name the lockable units in DB2?

641


What is the physical storage length of time data type?

641


How would the varchar column remarks defined?

603


How does cobol compile db2 program?

588


What is deadlock in db2?

558