how can I tell the DB2 Load Utility to stop if any row is subject to discard ?
DISCARDS 0 means no limit, all rows can be discarded
DISCARDS 1 means at least one row can be discarded
I'm working with DB2 V9.1
Thanks in advance for your help
This topic has been locked.
2 replies Latest Post - 2011-05-19T08:39:42Z by SystemAdmin
Pinned topic DB2 LOAD Utility, no discards
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-05-19T08:39:42Z at 2011-05-19T08:39:42Z by SystemAdmin
Re: DB2 LOAD Utility, no discards2011-05-18T11:20:42Z in response to SystemAdmintsx, Not sure of exactly what you goal is but DISCARD 1 is what you want if you want the Load to abend on the first Discard row found.
DISCARDS integer Specifies the maximum number of source records that are to be written on the discard data set. Integer can range from 0 to 2147483647. If the discard maximum is reached, LOAD abnormally terminates, the discard data set is empty, and you cannot see which records were discarded.
So when the Load finds 1 discard row, the Load will abend and the row will be deleted from any Discard file you may have allocated.
Re: DB2 LOAD Utility, no discards2011-05-19T08:39:42Z in response to SystemAdminSDas, thanks for the hint, indeed DISCARDS 1 is want I wanted, I think I mixed something up. I thought one row can be discarded but it means if at least one row is subject to discard DB2 will abend.