MULTILOAD CONSTRAINTS

General
Enthusiast

MULTILOAD CONSTRAINTS

Hi all,Multiload is used with NUSI but can anyone explain why multiload is not used to load into tables which are defined with USI.
Tags (1)
3 REPLIES
Enthusiast

Re: MULTILOAD CONSTRAINTS

Multiload cannot handle records which span vprocs.
If a table has a NUSI defined, the index entry for that record is on the same vproc as the record itself. If the table has a USI, the index entry will usually hash to a different vproc from the data record.
Join index and referential integrity are ruled out for the same reason.
Enthusiast

Re: MULTILOAD CONSTRAINTS

Amp local operations are allowed in Multiload. But Amp interdependancy operations are not allowed in Multiload. That the reason why USI/JI/RI are not allowed in Multiload.
Enthusiast

Re: MULTILOAD CONSTRAINTS

As per knowledge am sharing,

Actually Mload works on NUSI because it is a AMP local (sub-table machenism)Operation.There is no need to dependent on Other Amps.
Note : No use of USI,JI,RI