Invalid combination of keywords generated for a load statement
Article ID: 201230
Updated On:
Products
Issue/Introduction
The Analysis of an RC/Compare strategy is generating an invalid combination of load statements.
LOAD DATA
INDDN PTILOAD
RESUME YES
REPLACE
LOG NO
ENFORCE CONSTRAINTS
DISCARDS 1
DISCARDDN TDISC
ERRDDN TERRD
MAPDDN TMAPD
WORKDDN (TSYUTD,TSOUTD)
STATISTICS INDEX(ALL) UPDATE ALL
SORTDEVT SYSDA
SORTNUM 0
Executing the generated DDL and utilities fails with the following error for the load utility
DSNU070I 280 08:43:47.08 DSNUGDFL - KEYWORD OR OPERAND 'REPLACE' INVALID
WITH 'RESUME(YES)'
DSNU070I 280 08:43:47.08 DSNUGDFL - KEYWORD OR OPERAND 'STATISTICS' INVALID
WITH 'RESUME(YES)'
The REPLACE and STATISTICS keywords are not valid with RESUME YES.
Why is this invalid combination of statements being generated and how can it be resolved?
Environment
Release : 20.0
Component : RCC
Resolution
This Analysis is using a customized model. In the load utility model, the REPLACE and STATISTICS keywords have been hard-coded with no conditional logic based on the value of the %RESUME symbolic variable. Given that these two keywords are not valid for RESUME YES then conditional logic is required to prevent this combination of keywords.
For example to only generate the REPLACE keyword when RESUME NO is generated then the following logic can be used.
#IF(%RESUME,=,NO)
RESUME NO REPLACE
#ELSE
RESUME YES
#ENDIF
Additional Information
You can find further information on this specific requirement in the manual under Model Services, frequently-asked-questions
For your information, when tablespace is not dropped and recreated, RESUME(YES) is generated for ALTER or COMPARE strategies. If the tablespace is dropped and recreated, then RESUME(NO) is generated for the first table and RESUME(YES) generated for other tables in the tablespace.
Feedback
