When is the skeleton cursor table created?
Answer / s
Skeleton cursor table is created when a new plan is bound.
Is This Answer Correct ? | 3 Yes | 0 No |
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?
Can we update view in db2?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is node in db2?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is normalization and what are the five normal forms?
why we go for SPUFI for creating tables or for sql queries?
What do you do to keep the cursor from closing after a commit?
What is a DB2 catalog?