Hi Friends,
I've column "Comment" in my source.I'm getting approximately 10000 character for that column.while reading the data from sequential file I'm getting below error.
<SF_Profiledb,0> Error reading on import.
<SF_Profiledb,0> Consumed more than 100000 bytes looking for record delimiter; aborting
<SF_Profiledb,0> Import error at record 0.
Can you please help?
Do I need to assign any Environment Variable to increase the size column capacity.
Can Datastage support 10000 character for one column.
Column size is too large
Moderators: chulett, rschirm, roy
Column size is too large
Abhinav
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Which, in turn, means that you have probably specified the wrong delimiter. Did you import the table definition for the file and load that into your job design (including Load on the Format tab)?
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.