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

Question Posted / guest

2 Answers
10302 Views
Deloitte, I also Faced
E-Mail Answers

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

How to execute stored procedures?

0 Answers

What is a cursor?

2 Answers

What is dbrm? What it contains? When it will be created?

0 Answers

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers TCS,

Where do you specify them?

0 Answers

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

How to select the duplicate rows from a table?

4 Answers

How to insert more than one record using insert?

7 Answers Atos Origin, IBM,

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers MCN Solutions,

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers IBM,

Which component is used to execute the sql statements?

0 Answers

For more DB2 Interview Questions Click Here