We use a standard template in the Description box in our stage properties, but when a job is closed and reopened all of the CR/LF characters appear to have been removed, and the text is collapsed into a single block. However, those characters are still present - if you copy the text, and paste it into Notepad then it will appear properly formatted, and if you move the cursor along the text using the arrow keys, it will pause between words that were separated by a CR/LF. Have any of you folks dealt with something like this before?
From time to time over the past few months, I've dug around in the forums, but none of my searching seems to have turned up anything because terms like "DataStage Stage description newline" appear in numerous forum posts on DsXchange.
Stage descriptions lose CR when jobs are reopened
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Fri Oct 01, 2010 2:45 pm
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Paul is correct. Cutting and pasting into Designer from Windows is a hit or miss issue. I have seen it break jobs. Underneath the covers in Universe char(13) and char(11) get mixed up with @FM. I have actually fixed these jobs by editing records in DS_JOBS and DS_JOBOBJECTS which I would never recommend.
I would try a different editor other than Notepad. Try one which you can switch from DOS CR/LF to UNIX LF or whatever it is. There are other control codes which can really mess up jobs so be careful. What you are doing is unsupported. I would have to edit the records to see exactly what DS_JOBOBJECTS really wants.
I would try a different editor other than Notepad. Try one which you can switch from DOS CR/LF to UNIX LF or whatever it is. There are other control codes which can really mess up jobs so be careful. What you are doing is unsupported. I would have to edit the records to see exactly what DS_JOBOBJECTS really wants.
Mamu Kim