topic Call function module. in Application Development and Automation Discussions

Call function module.

Former Member — Thu, 06 Jul 2006 20:11:45 GMT

A program we have running in prod is calling

BG00_WARRANTY_LINK_UPDATE

The program has been running since yesteday and is not showing that there are any updates or inserts happening on the database.

The func mmod does actaul open SQL , UPDATE , INSERT. It is not called in update task... so when is the data committed ?

BAR

Former Member — Thu, 06 Jul 2006 20:16:11 GMT

If u r calling the function in ur custom program u need to explicitly commit the data if the function does not return any errors.

If u r not explicitly commiting the data the program will commit the data when it finishes processing.

However it is advisable to commit after say every 50 records so that u do not lose data if the program errors out after processing some data.

-Kiran