File Notification

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
senthilmp
Participant
Posts: 85
Joined: Mon Sep 22, 2008 6:11 am

File Notification

Post by senthilmp »

Hi,
I am capturing the reject records in a file by using OUTPUTLINK.REJECTED, now what am trying to do is when the file (which holds rejected record) is not empty then a notification mail should be sent. and if the file in empty then the notification mail should nt be sent.

Pls help me out in doing this.

Thanks for you time,
Regards,
Senthil MP
hamzaqk
Participant
Posts: 249
Joined: Tue Apr 17, 2007 5:50 am
Location: islamabad

Post by hamzaqk »

this is more or less the same

viewtopic.php?p=305786#305786
Teradata Certified Master V2R5
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, an O/S command or a custom routine to check to see if a file is empty or not can be used, or a DSGetLinkInfo check for zero records could be done.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply