What do you mean by commit and rollback?
- 1 Answers
- 1108 Views
- I also Faced
- E-Mail Answers
Answer / Upendra Kumar Raj
In DB2, a commit confirms all SQL transactions that have been executed since the last commit or rollback. A rollback undoes changes made by one or more SQL statements and returns the database to its state before those statements were executed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
what is the process of precompiler?
how can u retrieve the data from null values using applicaion program.
What is buffer pool in the db2 database?
What is a DB2 access path?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the EXPLAIN statement?
What is REORG? When is it used?
What's the maximum number of characters that a tablename can have?
What does reorg do in db2?
Update command
COBOL 
