topic Re: Insert statement not working without using ( wait or commit ) statements in Application Development and Automation Discussions

Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 07:05:09 GMT

hi all,

There is an insert statement which was working fine 2 days back. But yesterday onwards it is not submitting the new record in the Z table. I have checked the sy-subrc which was 0, but if i add ( wait or commit ) statement under insert statement then it works fine.

can anyone plz suggest the possible reason of this unusual behaviour of system

thanks in advance,

Aditya Goel

Re: Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 07:13:39 GMT

But always good programming prectice to use Commit.

Re: Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 07:16:33 GMT

Better to use commit work

If the program terminate after execution of insert statement the record doesn't commit to data base. that is the reason better to use commit work after insert statement.

Re: Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 07:22:20 GMT

yes u r absolutely right, one must use commit statement after insert. But i just want to know what could be the reason for not submitting the data in z table

Re: Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 07:27:50 GMT

I already told you, until unless program successfully execute then only the data will be summited to your ztable(if no commit work statement)

if you write commit work statement after insert statement, if your program anything goes wrong in middle at that point of time how many records are processed those records will be saved in your ztable.

Re: Insert statement not working without using ( wait or commit ) statements

Former Member — Thu, 28 Aug 2008 17:53:51 GMT

Its better to use COMMIT after DML (Update, Insert, Delete) statements.

For DDL statements, you don't need a COMMIT. They are auto commit.

Thanks,

Kartavya

Re: Insert statement not working without using ( wait or commit ) statements

Subhankar — Fri, 29 Aug 2008 06:32:18 GMT

Hi ...

With out using COMMIT WORK insert will work properly. After the execution of the program IMPLICIT commit occurred.

Please check the table ofter execution of the program.

If it not work then please check the data you want to insert. If you use ACCEPTING DUPLICATE KEYS and data are same then sy-subrc will be 0 but no record will be inserted again... Please check the key fields.

Edited by: Subhankar Garani on Aug 29, 2008 8:34 AM