SQL UPDATE not updating all rows

I use RUNSQLSTM in a CLLE pgm (interactively) to process a source member
that does the following:

-- insert rows into TABLEB from TABLEA where they do not already exist in
TABLEB
-- update TABLEC where the row exists in TABLEB (note: all rows in TABLEB
DO exist in TABLEC)

The first insert works fine. However, the update is not updating all of
the rows in TABLEC that it should. If I run the same SQL stmt using
interactive SQL, all rows in TABLEC are updated properly. I use
COMMIT(*NONE) and CLOSQLCSR(*ENDMOD) on the RUNSQLSTM. It seems that the
rows inserted into TABLEB have not been committed before the update stmt
processes them..

Is this because I use CLOSQLCSR(*ENDMOD)? If so, how can I better handle
this. Do I need to break out the update of TABLEC into another RUNSQLSTM
process?

Thanks.