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 are closed.