How do you select a row using indexes in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are some characteristics of columns that benefit from indexes?
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.
Is there any advantage to denormalizing DB2 tables?
What are the functions in DB2?
What is deadlock in db2?
when does the SQL statement gets executed when you use cursor in the application programming ?
How does db2 sample database connect?
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?
What do you mean by storage group (stogroup)?
What happens to a cursor after a commit?