Hi ...
I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job.
Any suggestions how to handle this
Send a notification mail when count mismatches
Moderators: chulett, rschirm, roy
Send a notification mail when count mismatches
D.N .MURTHY
Re: Send a notification mail when count mismatches
Compare the two counts may be likedr.murthy wrote:Hi ...
I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job.
Any suggestions how to handle this
if count1=count2 then 'Y' else 'N' and use DSSETUSERSTATUS routine
and then send a notification only when userstatus='N'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why bother with the "Y" and "N"?
Code: Select all
If Count1 <> Count2 Then Call DSSetUserStatus(arg) Else NULL
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.