How do we comit a db2 insert query before GOBACK statement in a cobol/ims/db2 program.
hai slnprasanna
after the insert query you just check the sqlcode. if its zero or anyother desired value, you give a COMMIT statement.
but i think by default there will be AUTOCOMMIT or AUTOROLLBACK option set which will take care of COMMIT or ROLLBACK based on the sqlcode return code. Please check whether that is the fesility available in your shop.
