topic Re: Regarding FM in Application Development and Automation Discussions

Regarding FM

Former Member — Wed, 07 Feb 2007 13:44:02 GMT

Can any one tell me what is the use of this two FM & where its used.

When will we use this FM.

call function 'DB_COMMIT'.

call function 'DEQUEUE_ALL'.

Thanks in advance

Re: Regarding FM

Former Member — Wed, 07 Feb 2007 13:47:09 GMT

DB_COMMIT -to trigger an explicit database commit in your application programs.The sole task of this function module is to start a database commit.

CALL FUNCTION 'DB_COMMIT'.

DEQUEUE_ALL - A lock remains set until you either call the corresponding DEQUEUE function module, or close the transaction with an implicit DEQUEUE_ALL.

call function 'DEQUEUE_ALL'.

Re: Regarding FM

Former Member — Wed, 07 Feb 2007 13:54:59 GMT

Hello,

DB_COMMIT -

Commit Work via EXEC SQL - no rollout database-independent form

according to the database system in

'DEQUEUE_ALL' -

It is used to Unloack all the object explicitely.

Vasanth

Re: Regarding FM

Former Member — Wed, 07 Feb 2007 13:55:26 GMT

<b>DB_COMMIT</b> is used to commit data to database...say, u have used insert <table name> in ur programs or so...and when u use this, the data is committed to the database.

<b>DEQUEUE_ALL</b> - Say, ur posting or doing something for a transaction, so a lock is set so as that other users will not access the same data at same time...This is used to unlock the transaction data.

Re: Regarding FM

Former Member — Wed, 07 Feb 2007 14:12:51 GMT

DB_COMMIT :

when you modify or create or delete andy rows of the database table in your program, you have to explicitly commit the work. If you dint do this commit , the changes will not be reflected in the database tables.

To explicitly commit a work related to the database, call the function module DB_COMMIT.

DEQUEUE_ALL:

When this fuction module executes , it realeses all the locked objects. fox example , if you or someother user locks a transaction for update process or for some reasons. In that case if you call the function module DEQUE_ALL, the locks are released.