Hello Everyone,
Sometimes (not always) when a file (flat file) is copied, either manually or via a .Bat file with the copy command, it produces this character "" at the end of the file which causes a datastage job to abort.
Can the row or the character be deleted before running the Server Job?
Thank you for your response in advance!!...
Rodre
where are you copying it from and where to. I use to see that character when i would ftp a file from mainframe to windows in ascii format. But if it was ndm'd (ftp'd) directly to a unix server, that 'box' wouldnt show up.
Does this box appear at the end of the last character or after the last row on a new line ?
Try by specifying "column has terminators", in the column specs in the seq. file stage. See if that helps.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
True.
As i mentioned, if it appears at the end of record then MCP conversion code can be used. If it appears in a new line, datastage will treat it as a new record with all the columns missing and hence scream.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
The file is ftp'd to us, however the copying is done within the datastage windows server, from one folder to another. Also, the original ftp'd file does not have the box character until the file is copied.
The box shows up after the last row on a new line.
I tried "column has terminators", it did not help.
Don't this need to be deleted before opening the file or would abort?
So what you are trying to say is, when you are picking up the original ftp'd file, there is no box present, but when you copy it a different folder it magically shows up???
How are you copying the file? Is via datastage job or through some other mechanism?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Ok. Did some testing.
Go to the Seq. File -> outputs tab -> columns.
Scroll right to the "Incomplete Column" property and select replace. What replace does is it replaces it with NULL.
This was atleast your job wont abort. You can then handle this particular row from not being passed on in the transformer by constraining it.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.