Reading data from a PSV 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
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Reading data from a PSV file

Post by suryadev »

the job has its finished but no records are loaded into the file.
the delimiter is pipe as there is no symbol of pipe I used "|" in the field defaults --delimiter.
when i view the log I see the below warnings

Sequential_File_38,0: Field "EntityID" has import error and no default value; data: <empty>, at offset: 9
Sequential_File_38,0: Field "FIRST_NAME" delimiter not seen, at offset: 55

please help me with a solution for this
Thanks,
Surya
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Search here for "has import error and no default value"
You are the creator of your destiny - Swami Vivekananda
vivekgadwal
Premium Member
Premium Member
Posts: 457
Joined: Tue Sep 25, 2007 4:05 pm

Re: Reading data from a PSV file

Post by vivekgadwal »

suryadev wrote: Sequential_File_38,0: Field "EntityID" has import error and no default value; data: <empty>, at offset: 9
Sequential_File_38,0: Field "FIRST_NAME" delimiter not seen, at offset: 55
These tell me that the Sequential file stage is not properly configured to read the data. Please check that, use View Data to make sure if you done so correctly.
Vivek Gadwal

Experience is what you get when you didn't get what you wanted
Post Reply