COMMIT_IN_POSTING
Hi experts
I have a problem with an output type of the sales orders, results that after creating a SAP sales order I need to create the same sales order in an informix system, so I'm connecting with DBCO to the informix database and executing some stores procedures with EXEC SQL. sentence, I have this instructions in the output type, then after executing each store procedure I'm executing and ENDEXEC and a COMMIT WORK, because If I don't use the COMMIT WORK from SAP the records I'm inserting in informix database are not inserted in Informix DATABASE, the program of the output type works fine when I run it separately, but when is executed after the VA01 or VA02, the system give me a dump with next error :
The question is , do I have another way to send the commit to the Informix database from SAP??.
Thanks
Regards
Soraya
*******************************************************
Errores tiempo ejec. COMMIT_IN_POSTING
ocurrido el 02.04.2009 a 15:31:26
Invalid COMMIT WORK in an update function module.
Calling a COMMIT WORK in an update process is not allowed
because the function modules triggered in a Logical Unit
of Work cannot then be processed correctly.
Former Member replied
Do not try COMMIT WORK
Commit the changes on connection
EXEC SQL. COMMIT ENDEXEC.
Thanks
Naresh