Is there any way that I would get the mload acquisition phase count in the mload script? MLOAD support environment provides different variables (total ins, upd, del etc.) at the application phase, but not at the acquisition phase.Is there any way other than scan the log file? Regds.
Hi Vikas,what version of MLoad are you using?MLoad supports that since several years:SYSAPLYCNTSYSNOAPLYCNTSYSRCDCNTSYSRJCTCNTCheck the manuals for details...Dieter
Dieter,Please correct me if I am wrong. These variables are used in the application phase of MLOAD. I am looking for count variables in the acquisition phase.Regds.
Hi Vikas,you are wrong ;-)But you can access those variables only after the END MLOAD.If you need that info *during* the load you'll have to program a NOTIFY exit.Dieter
You are right. Thanks. I have one more problem while implementing the alert mechanism.Basically when these is any error table generated during the MLOAD, I want to send an email. As per the manual, if we insert the row in this table, email will be sent.INSERT INTO dbcmngr.AlertRequest VALUES (DATE '2006-03-07',154600, 'Job1', 'Load job completed', 0,'E', 1, 'firstname.lastname@example.org','This message indicates that the load job completed!');I have done this, but just this doesn't work. Are there any more settings required? If anyone has done this before, please let me know.Thanks.