unable to view data from CSV file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vsandu
Participant
Posts: 13
Joined: Mon Aug 09, 2010 3:50 am

unable to view data from CSV file

Post by vsandu »

hi ,
i have source file CSV file , and i am using seq file satge , after importing meta data when i am trying to view data it is showing error,
can uoy please guiode me
thanks in advance
Venkat Sandu
vsandu.cg@gmail.com
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not without more information, say for example... your error? A description of the sequential file and the settings you are using in the stage would help, as well.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vsandu
Participant
Posts: 13
Joined: Mon Aug 09, 2010 3:50 am

Post by vsandu »

i am using datstage v 8.0 , and i am getting error like
1.the memory usage is exceded 100,000 bytes and expecting delimitor ;
Venkat Sandu
vsandu.cg@gmail.com
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Your structural metadata (on the Format tab) are not correct for the file. In particular the record delimiter (or record delimiter string) property is incorrect.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
manoj_23sakthi
Participant
Posts: 47
Joined: Tue Feb 23, 2010 12:16 am
Location: CHENNAI

Post by manoj_23sakthi »

hi,
Ray may correct . I too face this same problem.

The metadata we got like sale dt,cross dt ...
we import the meta and proceed but we are not able to proceed ..

then we correct the metadata like sale_dt,cross_dt,...
and it works..

Regards,
Manoj kumar
Post Reply