![Wink :wink:](./images/smilies/icon_wink.gif)
Field with 'delim=end' did not consume entire input
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Hi All,
Firstly I would like to thank everyone for their contribution and help.
I finally got the solution. PHEW!![Smile :)](./images/smilies/icon_smile.gif)
The field delimiter -Quote=double was given.
Within the data, in some record or the other, double quotes were present. Due to this, DataStage was rejecting the records.
I changed the value of Quote and it works fine
Regards,
Deepa
Firstly I would like to thank everyone for their contribution and help.
I finally got the solution. PHEW!
![Smile :)](./images/smilies/icon_smile.gif)
The field delimiter -Quote=double was given.
Within the data, in some record or the other, double quotes were present. Due to this, DataStage was rejecting the records.
I changed the value of Quote and it works fine
![Smile :)](./images/smilies/icon_smile.gif)
Regards,
Deepa