datastage

karthegx · Post by **karthegx** » Wed Sep 06, 2006 2:39 am

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.

ArndW · Post by **ArndW** » Wed Sep 06, 2006 3:42 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 06, 2006 4:39 pm

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().

kumar_s · Post by **kumar_s** » Wed Sep 06, 2006 7:36 pm

Hi karthegx,
When you create a post, Pls have more relevent topic like "Job Log/Report in Sequential File" given to that. That will help person who answers the post, as well as those who search forum later.