What is db2 and what is the use of db2 optimizer?


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

Post New Answer

More DB2 Interview Questions

How does one remove entries from the SCT02 table?

1 Answers  


What is the purpose of the WHENEVER statement?

1 Answers  


how do you resolve -805?

3 Answers   HCL,


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


What is a db2 cursor?

0 Answers  






assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


Is there any advantage to denormalizing DB2 tables?

1 Answers  


My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,


What is the physical storage length of timestamp data type?

0 Answers  


What is cursor with hold option in db2?

0 Answers  


What is the picture clause of null indicator variable?

0 Answers  


Categories