By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Load Utility

P: 2
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
Dec 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 3
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.
Dec 13 '07 #2

P: 2
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.
Dec 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.