(Just saw that Ray posted before me - how did he manage to sneak in there?)
JezT,
No, nothing so complicated. Go to the column definitions and change the value of "Contains Terminators" to "Yes" (you usuually need to page the column definition window to the right to see it). For more information, call up help in the designer and search for the keywords "contains terminator".
DataTypePicComp
Moderators: chulett, rschirm, roy
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hello again JezT,
the data contains <LF>, your viewing program is looking at the data as text and is displaying the <LF> the way it is supposed to - by showing the data on the next line. Do you have a Hex or Binary editor on your host? This would show the data the way it is really stored. Remember that this is binary data and is not meant for your run-of-the-mill text editor.
Since you are having trouble with the COMP fields, can you have your COBOL programmer just change the definitions to PIC 9(9) fields for this run? Then you would not need the conversion and reconversion and could use a text editor on the UNIX or Host side to see your data?
the data contains <LF>, your viewing program is looking at the data as text and is displaying the <LF> the way it is supposed to - by showing the data on the next line. Do you have a Hex or Binary editor on your host? This would show the data the way it is really stored. Remember that this is binary data and is not meant for your run-of-the-mill text editor.
Since you are having trouble with the COMP fields, can you have your COBOL programmer just change the definitions to PIC 9(9) fields for this run? Then you would not need the conversion and reconversion and could use a text editor on the UNIX or Host side to see your data?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Arnd
Unfortunately the file is required in Binary format so is there any way round this problem of the line terminating ?
Why did the "Contains Terminators = YES" work before we made the field EBCDIC but after it had already been converted by your routine ?
Is it likely that the problem is being caused by our file transfer and not within DataStage ?
JezT
Unfortunately the file is required in Binary format so is there any way round this problem of the line terminating ?
Why did the "Contains Terminators = YES" work before we made the field EBCDIC but after it had already been converted by your routine ?
Is it likely that the problem is being caused by our file transfer and not within DataStage ?
JezT
Craig - our method lies in the use of sparse one-liners. :D
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>