DSjobreport

ann · Post by **ann** » Mon May 23, 2005 12:22 pm

Hi,
I am trying to get job info with DSjobreport routine as after job routine. But my text file is a sigle row result. which is like as fallows

**************************************************
STATUS REPORT FOR JOB: Extractfile
Generated: 2005-05-23 13:34:32
Job start time=2005-05-23 13:34:30
Job end time=2005-05-23 13:34:32
Job elapsed time=00:00:02
Job status=1 (Finished OK)
and the problem is in this text file carieage return becomeing a small box kinda character. When i am trying to read the file it is giveing me error "too many cols in a row"

help please

amsh76 · Post by **amsh76** » Mon May 23, 2005 12:32 pm

How you are trying to read the file? I think your problem is with the column delimiter...

ann · Post by **ann** » Mon May 23, 2005 12:56 pm

PRoblem is with the txt file. In my txt file the new lines became a . they are in one row.

ray.wurlod · Post by **ray.wurlod** » Mon May 23, 2005 5:29 pm

Welcome aboard! :D
My guess is that it's writing UNIX-style line terminators (LF) rather than Windows-style line terminators (CRLF). If you open with, say, Word you can convert them. There are also converter programs out there, such as unix2dos, that will perform these conversions.
(Or you could create a DataStage job to do the conversions!)

Code: Select all

SeqFileStage  ------>  SeqFileStage

Set the stage property "line terminator" on the source stage to "UNIX" and on the target stage to "DOS". Process the entire line as a single VarChar column.

wilcywilliam · Post by **wilcywilliam** » Mon May 23, 2005 11:49 pm

XML report can be obtained by specifying argument 1 of the DSJobReport routine 'report type' as '2'. Argument 3 of the DSJobReport routine 'XSL stylesheet' optionally specifies an XSL style sheet to format an XML report.

ArndW · Post by **ArndW** » Tue May 24, 2005 12:08 am

Doesn't the DSJobReport use @FM as a separator? You can do CONVERT(@FM,'~',YourString) to check