[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

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?
0
eddiedelgado
Asked:
eddiedelgado
  • 3
  • 2
1 Solution
 
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
 
eddiedelgadoAuthor Commented:
I figured out how to do this.  I needed to use the "MODIFIED BY RECLEN=x" in my LOAD command.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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
 
Computer101Commented:
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now