Hi,
I am reading data into a sequential file with all columns specified as varchar. well in some records there are special characters which are causing them to be dropped( at seq file stage). i hhave enabled NLS, whch NLS map would handle all special charactes??? so that i can alteast read all records
problem with special characters!!!
Moderators: chulett, rschirm, roy
-
zulfi123786
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
stefanfrost1
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
Could you please supply the drop warning written to your job log?
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: