WHAT IS MEANT BY COMMIT COMMAND?

Answer Posted / labog

Commit saves all the changes made to the database and
closes all Cursors opened except the Cursors with WITH HOLD
option.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1984


Is schema the same as database?

718


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


How to take backup of table in db2?

670


What do you mean by between and in? Is between inclusive of specified range values?

769






How to find the maximum value in a column in the db2 database?

687


How can we read records for specific member in CL? AND rpg?

323


What is bufferpool in db2?

664


What is collection in db2 bind?

665


What is the function of logging in the db2 database?

730


What is a db2 package?

681


Give a brief description of db2 isolation levels?

689


Mention the downsides of page level lock.

813


My sql statement select avg(salary) from emp yields inaccurate results. Why?

736


What is nvl in db2?

727