Difference bw load resume and load replace

dasan · New User Joined: 24 Oct 2006 Posts: 10

Hi all,
What is the difference between a load resume and load replace?

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

LOAD REPLACE - newly loaded rows replace all existing rows of all tables in the table space, not just those of the table you are loading.
LOAD RESUME will insert only new rows, keeps existing rows. And has two options ( NO / YES )

Refer to following link for details

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH11/2.12.1.2?SHELF=DSNSHHA1&DT=20010719144747&CASE=