Import warning with sequential 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
dodda
Premium Member
Premium Member
Posts: 244
Joined: Tue May 29, 2007 11:31 am

Import warning with sequential file

Post by dodda »

Hi all,

I need some help regarding importing the .txt file to my unix server.

I FTP the file from my system to unix server.
Here iam using a WINSCP tool for FTP purpose.

Here iam using sequential file as a source .
The following are the warnings iam getting while i run the job.
1.Testdata,0: Missing record delimiter "\n", saw EOF instead
2.Testdata,0: Import warning at record 15

Here my source data contains 16 records.
Plz let me know the reasons for this one.

Your help is greatly appreciated.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Re: Import warning with sequential file

Post by ArndW »

dodda wrote:...Missing record delimiter "\n", saw EOF instead...
is the important part. You haven't defined line terminators identical to your file contents.
patil.bnk
Participant
Posts: 5
Joined: Tue Jun 24, 2008 4:45 am
Location: banglore

Post by patil.bnk »

i think you should declare the end of line
Thanks and Regards
patil
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

is it delimited file or fixed width?
Post Reply