How to retrieve rows from a db2 table in embedded sql?


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

Post New Answer

More DB2 Interview Questions

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


How to compare data between two tables in db2?

0 Answers  






Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


What are the prerogatives?

0 Answers  


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  


What are concurrency issues?

0 Answers  


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


Categories