DB2 z/OS LOAD IGNORE WHEN
Mit PTF PI44415 stellt IBM für DB2 10 und 11 for z/OS eine neue LOAD Option zur Verfügung:
New function to enable LOAD IGNORE(WHEN) to ignore records which do not satisfy the WHEN clause.
IGNORE(WHEN) will cause LOAD to ignore records which do not
satisfy the WHEN clause.
----+------------------+-->
| |
'---IGNORE(WHEN)---'
IGNORE(WHEN)
Specifies that records that do not satisfy the WHEN clause
will be ignored. If discarding is specified, records that do
not satisfy the when clause will not be loaded, and will not
be written to the DISCARD data set. If discarding is not
specified, records that do not satisfy the WHEN clause do not
cause LOAD to terminate.
Use the record count messages in the Utility output to
determine the number of records ignored.
Under the WHEN clause description:
The option following WHEN describes a condition; input records
that satisfy the condition are loaded. Input records that do
not satisfy any WHEN clause INTO TABLE statement are written
to the discard data set, if one is being used and the
IGNORE(WHEN) option is not specified.
Mehr Informationen zur neuen LOAD Option gibt es unter http://www-01.ibm.com/support/docview.wss?uid=swg1PI44415




Comments
Comments are closed.