Hi,
i have one text column in one file. I am trying to read that column by varchar or long varchar. Now the problem is the data which are coming are so big, DS is not able to read full data. Data which exceeds the maximum length got truncated. Do we have any data type which can raed more character than long varchar? or is there any other solution to read the entire data?
Unable to read entire data of a text col when data is huge
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai
What limit have you reached, i.e. at what length does truncation occur? Since your file contains only one column per row, you could declare your data as having 2 columns and declaring the file without a column separator.
Do you need to process this long column?
Do you need to process this long column?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 2
- Joined: Tue Jul 13, 2010 11:37 am
- Location: Chennai
Another useful question is exactly how large are we talking about?
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the "Data which exceeds the maximum length got truncated" message occurred in the data browser (view data), that's a limit in the data browser only. You should ignore it.
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.