what is the use of commit ? and what is the syntax?
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 |
Write a query to extract first 5 characters of a name in the column Stud_Name?
what is utility for parm lib
What is null indicator in cobol db2?
What will the FREE command do to a plan?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Are views updateable?
What is a db2 package?
What is a system catalog table in db2?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Name the various locking levels available?
List down the data types in the db2 database.
What is role in db2?