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
DSjobreport
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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!)
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.
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
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.
-
- Participant
- Posts: 12
- Joined: Tue Dec 21, 2004 7:57 am