hai all,
after completing the parallel job the errors should be present in the sequential file. i need data in this format file started: 09/02/2006 12:11:38 AM
MESSAGE ( 241): " ****** Beginning transfer of crept_media at: Sep 2 2006 12:11:38:456AM "
MESSAGE ( 241): " ****** THERE IS NO DATA TO PROCESS TODAY ******"
MESSAGE ( 241): " ****** Total inserts: 0"
MESSAGE ( 241): " ****** Total updates: 0"
MESSAGE ( 241): " ****** Total deletes: 0"
MESSAGE ( 241): " ****** Total insert rejects: 0"
MESSAGE ( 241): " ****** Total update rejects: 0"
MESSAGE ( 241): " ****** Total delete rejects: 0"
MESSAGE ( 241): " ****** Total rows processed: 0"
MESSAGE ( 241): " ****** Total rows in error not counting trigger errors: 0"
MESSAGE ( 241): " ****** Total rows unknown: 0"
MESSAGE ( 241): " ****** Ending transfer of crept_media at: Sep 2 2006 12:11:40:166AM "
i think we can write subroutine , can any one help upon this.
and the second thing is i want to send all these errors in mail using job sequence.
datastage
Moderators: chulett, rschirm, roy
Hello Kartheek and welcome to DSXchange!
The information that you want to put in the sequential file is available after a job completes by using calls to builtin routines such as DSGetJobInfo(), DSGetLinkInfo() and DSGetStageInfo(). You can also access quite a lot of this information from the dsjob command line program if you prefer to code in the shell versus writing your own DS/Basic code.
The whole routine to do what you would like is big enough that nobody will just write it for you, but if you start doing the work yourself and get stuck or have specific you will find the people here very supportive and helpful.
The information that you want to put in the sequential file is available after a job completes by using calls to builtin routines such as DSGetJobInfo(), DSGetLinkInfo() and DSGetStageInfo(). You can also access quite a lot of this information from the dsjob command line program if you prefer to code in the shell versus writing your own DS/Basic code.
The whole routine to do what you would like is big enough that nobody will just write it for you, but if you start doing the work yourself and get stuck or have specific you will find the people here very supportive and helpful.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is there some significance of (241)?
Arnd is right that it's too long a routine for anyone to assay without payment. But we can help you to address any issues you have in creating it yourself.
Research OpenSeq, WriteSeq and CloseSeq as mechanisms for working with text files. Search the forum for a useful function called OpenSequentialFile().
Arnd is right that it's too long a routine for anyone to assay without payment. But we can help you to address any issues you have in creating it yourself.
Research OpenSeq, WriteSeq and CloseSeq as mechanisms for working with text files. Search the forum for a useful function called OpenSequentialFile().
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.