How do you select a row using indexes in db2?


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

Post New Answer

More DB2 Interview Questions

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


What are the functions in DB2?

3 Answers   Satyam,


What is deadlock in db2?

0 Answers  


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


How does db2 sample database connect?

0 Answers  


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


What do you mean by storage group (stogroup)?

0 Answers  


What happens to a cursor after a commit?

3 Answers  


Categories