LOAD using clause WHEN

Livia Gomes da Silva

LOAD using clause WHEN
Hi list,
I'm using LOAD utility with clause WHEN, to load records that satisfy the specific condition.
During the execution, I'm receiving warning messages DSNU314I.
DSNU314I < DSNURWBF - RECORD (1) WILL BE DISCARDED DUE TO WHEN SPECIFICATION(S)
I would like to suppress this messages.Does anyone know how to do this?

Thanks

Lívia Gomes da Silva
DBA - DB2
Caixa Seguros - Brazil

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

K.A.Rodriguez

Re: LOAD using clause WHEN
(in response to Livia Gomes da Silva)
You can eliminate the DSNU314I messages by removing the SYSDISC DD from
your JCL. However in doing so you run the risk of not knowing if any
records were discarded for reasons other than not matching the WHEN
specification.
Kim

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm