Loading a Fixed text file without Carriage Return and Line Feed

I am having a problem using LOAD in DB2 v8.1.  I am trying to load a fixed length text file that does not have a carriage return and line feed at the end of each record.  The entire text file continues on one line.  I have tried to load the file using "METHOD L" in my LOAD script but it doesn't seem to be working.  Does anyone know how I can load the text file without a carriage return and line feed?
eddiedelgadoAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed, with points refunded (125)

Computer101
E-E Admin
0
 
ghp7000Commented:
post the load command you are using please
0
 
eddiedelgadoAuthor Commented:
I figured out how to do this.  I needed to use the "MODIFIED BY RECLEN=x" in my LOAD command.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
eddiedelgadoAuthor Commented:
I figured out how to do this.  I needed to use the "MODIFIED BY RECLEN=x" in my LOAD command.
0
 
eddiedelgadoAuthor Commented:
I figured out how to do this.  I needed to use the "MODIFIED BY RECLEN=x" in my LOAD command.
0
 
ghp7000Commented:
please post a request in community support to have your points refunded and this question removed from the active list
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.