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.
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.