Query in BMC Load

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Dear All,

Iam having a query in BMC load.

I want to load some datas into a table which is already having some rows and suppose if iam adding a duplicate row, i mean during my load if there is any violation of unique index happens, is there any option to override that while loading itself? I.e I mean to say that i want to skip the record while loading if there is already a row of same index value.

Hope Iam clear on my query. If you need any clarifications regarding that please make a note to me.

Thank You.

shaik Madar vali · New User Joined: 28 Apr 2005 Posts: 8

Hi,

DISCARD 0 in Load Card will discard if the record duplicate..

LOAD DATA LOG NO RESUME NO REPLACE NOCOPYPEND
STATISTICS TABLE ALL INDEX ALL DISCARDS 0

regs,
Vali

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Thanks Vali.....

Thats sounds interesting. I'll try that and let you know.

Regards,
----------

RAJ1965 · New User Joined: 07 Aug 2006 Posts: 6

I need to find all the points of update done to the DB2 tables.
How can I read the DB2 LOG to find the information.
What is the record layout of the log?
Can anyone help me?