CPYTOIMPF

[jmanj]

This may be an offside question to this forum but I'll
try anyway.

I have a file whose record length is more than 28000 bytes
and more than 350 fields. How will I copy this file to IFS
using other than cpytoimpf without splitting it? Right now cpytoimpf could not handle this file. It gives an error message that the job ended in error and that no record was written.

I have another file whose record length is about 13000 and
cpytoimpf was able to handle it without a problem.

My purpose is to convert these files into a csv file then run
my perl program to strip each field of (right/left) spaces. These way it is easier for my clients to read the file.

Thanks for any help

jmanj

 

[MdnghtPgmr]

jmanj,

What is the error message? I am not aware of any size limitation on the CPYTOIMPF command.

MdnghtPgmr

 

[jmanj]

MdnghPgmr,

Thanks for the fast reply. The error is just a common IFS message when nothing has been written to the target file. The
message itself does not really point you to a particular issue(vague). I copied 1 record from the file and still CPYTOIMPF could not handle it. I have read some documentation that CPYTOIMPF cannot handle LOB files. I'm just wondering if this file can be considered LOB type.

For now I have to split the file and rejoin them in ACCESS then export it to EXCEL.

Thanks.

jmanj