Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10198 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p.shravani
commit is a command.It is used to make the changes permanent
on the storage when the transaction is successfully
processed or execute.
syntax
exec sql
commit
end-exec.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / yuvaevergreen
Commit statement is an explicit way of mentioning that
>>any changes should be committed to the object.
>>any locks to be released from the particular object
(except WITH HOLD cursor)
I hope syntax should be
EXEC SQL
COMMIT
END-EXEC.
| Is This Answer Correct ? | 11 Yes | 0 No |
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is clone table?
Explain db2.
I use CS and update a page. Will the lock be released after I am done with that page?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is an instance in db2?
how to resolve -811
Explain various types of locks in db2?
what is the sqlcode -501
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
what is the responsibility of the construction superintendent
What is rebind in db2?
COBOL 
