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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


What is a db2 table?

0 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


What are the contents of a dclmgen?

0 Answers  


When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


Why do chiropractors use drop table?

0 Answers  


Define sqlca.

0 Answers  


What is a DB2 access path?

1 Answers  


Categories