Hi All,
I am having a funny problem in reading a source file in my DS job.
Actually the source file is '~' delimited. In the file last column is having null in all the records, not even spaces. Now datastage is not reading that column and throwing "Read File Delimited" error. can u please suggest some thing. I tried everything from opening it in XL, to saving it as CSV, but it did'nt work.
source file delimiter error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
source file delimiter error
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0
How about using the attribute for "incomplete column"?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Parag,
go into your designer sequential file stage in the columns tab, and scroll to the right to see the incomplete column column. Also, try using the HELP and search for incomplete.
go into your designer sequential file stage in the columns tab, and scroll to the right to see the incomplete column column. Also, try using the HELP and search for incomplete.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Columns grid scroll right and you will find rules that can be set on a per-column basis, including incomplete and "contains terminator" rules. Set the incomplete rule to Replace. Click on Help while there to learn more about the precedence requirements of these rules.
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: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Both Ray and I suggested you read the HELP regarding how to set the incomplete columns. From the question in your post it would seem you decided not to follow that advice! Only columns starting at the end of the line and going backwards can be set to incomplete.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>