Update not journalized file

["Xu, Weining" <Weining.Xu@xxxxxxx>]

Hi,

I have a Java program run on AS400 using native JDBC driver.  I have no
problems to insert, delete or update any tables in DB2 database on AS400,
but when Java program inserts data from DB2 table into a flat file on AS400
library(which is not journalized), the error message says the file is not
journalized, that makes sense.  But I can do the same insert SQL statement
from Operation Navigator's SQL Editor.  I thought that may be autoCommit was
not set up as true, so I specifically set the autoCommit as true in program.
It still failed.  In this case, I do not need the file be journalized in
order to rollback.

I am not quite sure why it is OK to run SQL statement directly, but failed
in Java program?  Any help??

Thanks,

Wayne