RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid

Database
Junior Supporter

RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid

Hi,

We have addedd a PPI on a column in a table and trying to update using mload. We get RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid.

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.

I have few quesrions:

1. Should the PPI also be part of the where clause in the update stmnt ? 

2. Do we need to include the ppi in the PI columns and then it should be mentioned in the where clause ? or can it not be part of PI and be mentioned in where clause ? Neways if it is made part of PI, it has to me mentioned in where clause as the PI should be fully qualified.

Thanks !

1 REPLY
Junior Contributor

Re: RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid

The rules for PIs in MLoad apply also to PPI:

All Primary Index columns plus all partitioning columns must be specified in the WHERE-caluse and must not be modified by an UPDATE, i.e. the ROWID can be calculated and doesn't change.