DB2 admin cmd switch off auto commit

Viewed 31

I want to execute this script but without commit, how to do it?

call SYSPROC.ADMIN_CMD(
'LOAD FROM (SELECT * FROM A) OF CURSOR INSERT INTO B'
);
1 Answers

No way.
LOAD implicitly commits a number of times during its execution, and you can't influence it.

Related