Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference


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

Post New Answer

More DB2 Interview Questions

What does db2 mean?

0 Answers  


For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  


What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  






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

3 Answers   Zensar,


How could one combine a set of incremental image copies into a single copy?

1 Answers  


Define buffer pool.

0 Answers  


Can you Average the Characters ?

3 Answers  


how to resolve -811

2 Answers   IBM,


What is a view? Why use it?

3 Answers  


How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,


Categories