Load Utility

[Sini Raghavan]

Hi,
Can anyone explain what does the following load utility option do all together.

LOAD DATA REPLACE INDDN SYSREC00 LOG NO
INTO TABLE DSN8810.ACT

Thanks & Regards
Sini Raghavan

[murugan1981]

Hi,


LOAD DATA REPLACE INDDN SYSREC00 LOG NO
INTO TABLE DSN8810.ACT


Above utility will load into DB2 with replace option, when it's LOAD DATA REPLACE what ever existing data avialable in the table will be over written with the load file which your going to load.

[venkateswari]

Hi,
Can anyone explain what does the following load utility option do all together.

LOAD DATA REPLACE INDDN SYSREC00 LOG NO
INTO TABLE DSN8810.ACT

Thanks & Regards
Sini Raghavan

Hi,,

Since its a LOAD REPLACE, the existing data in the table will be overwritten by the new data you are going to load.
If you dont want this to happen, then give RESUME instead of REPLACE.