All Forums Tools
Vik2006 5 posts Joined 03/06
06 Mar 2006
MLOAD acquisition phase count

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.

dnoeth 3150 posts Joined 11/04
07 Mar 2006

Hi Vikas,what version of MLoad are you using?MLoad supports that since several years:SYSAPLYCNTSYSNOAPLYCNTSYSRCDCNTSYSRJCTCNTCheck the manuals for details...Dieter

Dieter

Vik2006 5 posts Joined 03/06
07 Mar 2006

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.

dnoeth 3150 posts Joined 11/04
07 Mar 2006

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

Dieter

Vik2006 5 posts Joined 03/06
07 Mar 2006

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, 'vikbarve@yahoo.com','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.

You must sign in to leave a comment.