I need to read an email within a datastage job. How can I do that ?
Any suggestions or experiences ? or is it really posssible...
many thanks
caltog
Read Email with Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why? (I'm always suspicious of queries that begin "I need to...", as they're often not well thought out.)
Do you only need to detect that the email has arrived, or do you need its content? Does your email client store email messages as text files or as encoded files - that is, are the email messages readily accessible via the file system.
In DataStage 6.0 you can use a front-end filter on the Sequential File stage to invoke an email reader; the output being streamed into the stage for processing as if it were a Sequential File. Otherwise (for example at earlier releases) you can create a before-stage or before-job subroutine to process the email message into a text file that DataStage can use, or use similar code in a job control routine to obtain the requisite information with which to set parameter values of child jobs.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Do you only need to detect that the email has arrived, or do you need its content? Does your email client store email messages as text files or as encoded files - that is, are the email messages readily accessible via the file system.
In DataStage 6.0 you can use a front-end filter on the Sequential File stage to invoke an email reader; the output being streamed into the stage for processing as if it were a Sequential File. Otherwise (for example at earlier releases) you can create a before-stage or before-job subroutine to process the email message into a text file that DataStage can use, or use similar code in a job control routine to obtain the requisite information with which to set parameter values of child jobs.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: