Mulitload - Error - MVS Host Message

[paulnlk4]

Hi,

I am trying to do a Multi-load and the table is defined as follows:
CREATE SET TABLE addr ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
(
ADDR_ID VARCHAR(22) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
ADDR_SYS_SRC_ID SMALLINT NOT NULL,
ADDR_USG_TYP SMALLINT NOT NULL,
SUBCNTRY_NM_EN VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
ADDR_LIN_1 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
ADDR_LIN_2 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
ADDR_LIN_3 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
ADDR_LIN_4 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
CTY_TWN_NM VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
PSTL_ZIP_CD VARCHAR(13) CHARACTER SET LATIN NOT CASESPECIFIC,
CNTRY_CD_ALPHA2 CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
SUCNTRY_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
CAPTR_DT DATE FORMAT 'YYYY-MM-DD' NOT NULL,
CHG_DT DATE FORMAT 'YYYY-MM-DD')

PRIMARY INDEX ( ADDR_ID ,ADDR_SYS_SRC_ID )
PARTITION BY RANGE_N(CAPTR_DT BETWEEN
DATE '2003-11-30' AND DATE '2005-11-30' EACH INTERVAL '1' MONTH );


I do a update first in Multi-load as follows:

UPDATE ADDR
SET SUCNTRY_CD = 'CA'
WHERE ADDR_ID = :IN_CLIENT_NUMBER
AND ADDR_SYS_SRC_ID = :IN_SYS_SOU_NUMBER
AND CHG_DT IS NULL
AND CAPTR_DT > '2003-10-31'
AND CAPTR_DT < '2005-11-30'
;

While doing update above, I get the following error message:

UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid.

Can somebody help me ASAP?

Thanks,
Paul

 

[WILLIEWANKA]

Could you post your code?

The manual gives this response to your error message

Explanation: The user has provided an UPDATE
statement in a MultiLoad Complex Import Task that
does not fully specify a primary index value, does not
fully specify the values of all the partitioning columns,
or modifies the primary index or partitioning columns.

Generated By: OPT modules.

For Whom: End User.

Remedy: Correct the error and resubmit the request.


The WHERE condition, including any taken from a
view definition, must allow for primary index access
(and, if partitioned, partition access) with possible
ANDed residual conditions. The list of updated fields
must not include any column in the primary index or
partitioning expression, and only one table may be referenced.
database.

 

[dnoeth]

As WILLIEWANKA pointed out you have to supply equality conditions for all columns in PI and all partitionin columns, but you use BETWEEN on CAPTR_DT (and it's totally useless).

AND CAPTR_DT = :CAPTR_DT

If you don't have CAPTR_DT in your input file, you got bad luck...

Dieter