Hi Aditya

It would be useful to know what connection parameters you are using to connect to the database. Is it possible that there is some "Auto Commit" parameter or setting in your database. It looks like the updates have been committed as they went and so your commit at the end was not needed. At what point in your code are you getting the error?

Regards

David

Seems the code commits for every row processed.  I may not opt for this commit, if the no. of rows in the dw_1 are not too high.  

And a possible solution to your issue could be,     (And I warn that this is not the best way to update)

SQLCA.Autocommit = False                         <=   Add this line
for ll_row=1 to dw_1.rowcount()
    lds_status = dw_1.GetItemStatus(ll_row, "last_add2", Primary!)
    if lds_status = DataModified! then
       ls_myprodno=dw_1.getitemstring(ll_row,"prod_no")
       ls_mybatchno=dw_1.getitemstring(ll_row,"batch_no")
       ls_lastadd2=dw_1.getitemstring(ll_row,"last_add2")
                        
       update dep_sub set last_add2=:ls_lastadd2 where prod_no=:ls_myprodno and batch_no=:ls_mybatchno  using sqlca;
                 
       update prod_det set last_add2=:ls_lastadd2 where prod_no=:ls_myprodno and batch_no=:ls_mybatchno  using sqlca;
                         
       update inv_sub set last_add2=:ls_lastadd2 where prod_no=:ls_myprodno and batch_no=:ls_mybatchno using sqlca;
                     
       update out_sub set last_add2=:ls_lastadd2 where prod_no=:ls_myprodno and batch_no=:ls_mybatchno using sqlca;
                         
       commit using sqlca;
    end if
next

SQLCA.Autocommit = True                         <= Add this line

HTH

Happiness Always
BKR Sivaprakash

Hi Aditya;

  FWIW: I do not see any error checking code being done after every Update command. So by the time you get to the Commit, your PB App cannot be sure whether a Commit is valid vs performing a Rollback if an error(s) exist. Food for thought.  HTH

  Also, how are you connecting to SS (DB Client driver) and what PB Version & build are you using??

Regards .. Chris