For a LOAD with FORMAT=BACKUP, you must use the new keyword LOADID=NO to force input to output matching, using table name not table DATACOM-ID. The name must be the Full Parent name against a Full Parent or if going from ID partitioning against an unpartitioned table. If the partition criteria do not now match, the row is rejected. If a row is rejected, the LOADPTN= keyword is used to control the action taken. If it is set to SKIP, the row is ignored with no error condition. If it is set to FAIL or allowed to default to FAIL, the row is dumped, and the utility function terminates.
For a LOAD with FORMAT=EXTRACT, input rows that do not match the partition values for the area are treated according to the LOADPTN option as previously explained.
The LOAD utility report provides information about row movement to different areas.
The following information is provided under NOTES on the load report when tables are partitioned:
Indicates record(s) from this table are to be skipped (not loaded) because they do not meet any of the range criteria for any tables in this partition.
Indicates the table was not loaded.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|