RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid
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.