what is the use of commit ? and what is the syntax?

Answers were Sorted based on User's Feedback



what is the use of commit ? and what is the syntax?..

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

what is the use of commit ? and what is the syntax?..

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

Post New Answer

More DB2 Interview Questions

What is a host variable?

3 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


How to see the structure of db2 table??

4 Answers   IBM,


Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  






How to access db2 tables in mainframe?

0 Answers  


How do you check for a null value in a db2 column?

2 Answers  


How does cobol compile db2 program?

0 Answers  


How do I copy a table in db2?

0 Answers  


What is a DB2 bind?

3 Answers  


What os does db2 run on?

0 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


Categories