What is the usage of open cursor command?


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

Post New Answer

More DB2 Interview Questions

What do you mean by NOT NULL? When will you use it?

3 Answers  


How will you return the number of records in table?

0 Answers  


why we create view.

5 Answers  


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  


Define predicate?

0 Answers  






In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  


Which is faster delete or truncate?

0 Answers  


How to create a table using embedded sql?

1 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


Categories