Hi All,
The Email parameters like FROM , TO and Subject will be stored in a table and i need to Read the content from the table and pass the values to the Notification Stage (at the sequence Job level).
How to implement this in DS ?
Thanks
Chillblue
Passing parameters to a Email Stage from Table
Moderators: chulett, rschirm, roy
Passing parameters to a Email Stage from Table
Thanks
Chillblue
Chillblue
Use a Server job to capture that information and store it (delimited) in USERSTATUS. The sequence can easily extract it from there and you can use Field() in the paramater assignment to split them back out.
A User Variables stage can also be handy here. If you'd rather not use USERSTATUS then a flat file can be leveraged as well for intermediate storage.
A User Variables stage can also be handy here. If you'd rather not use USERSTATUS then a flat file can be leveraged as well for intermediate storage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm
Even if you write a parallel job, you don't need to have 3 stages to read and 3 files.
Read the data from Oracle and write on a single file.
For example,
Test.txt
abc@gmail.com~def@gmail.com~Test Mail
And then read the file using CAT command in unix.
And later using FIELD() in the parameter assignment to split them where '~' will be delimiter.
This way you need
Oracle Extract ----> Execute Stage ------> User Variable Activity ----> Mail Notification
Read the data from Oracle and write on a single file.
For example,
Test.txt
abc@gmail.com~def@gmail.com~Test Mail
And then read the file using CAT command in unix.
And later using FIELD() in the parameter assignment to split them where '~' will be delimiter.
This way you need
Oracle Extract ----> Execute Stage ------> User Variable Activity ----> Mail Notification
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm