Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of commit ? and what is the syntax?
- 2 Answers
- 10417 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 |
What is PRIME TABLE and what are the uses of it
Why do chiropractors use drop table?
When DB2 connection fails, will online program work or give errors.
How we create a tables in db2,what is the process/syntax to create a table with example plz?
Define data page.
How can you display the current date & current time ?
What information is used as input to the bind process?
How can the duplicate values be eliminated from db2 select?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Which catalog table stores referential constraints?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
When is the results table for the query in a DECLARE CURSOR statement created?
COBOL 
