45 pts.
 Client Access CRLF
I have a 240 byte flat file on my AS/400. I am using client access to move it to a PC. This works fine except client access put a CRLF at the end of every record. Does anyone know a way to make this stop?

Software/Hardware used:
ASKED: October 6, 2008  5:40 PM
UPDATED: October 8, 2008  2:45 PM

Answer Wiki:
I believe that's an automatic function of iSeries Access, and that you can't change it. To get around, you could try copying the file to the IFS using the CPYTOIMPF command, where you could choose the end of record character or combination that you want (CRLF, LF, CR, or LFCR).
Last Wiki Answer Submitted:  October 8, 2008  1:38 pm  by  Cwc   4,275 pts.
All Answer Wiki Contributors:  Cwc   4,275 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Try using the DOS Random file type for the transfer. According to the help text :

DOS random

DOS random files are fixed-length files that are used by the DOS random read and write routines. They do not have any end-of-record or end-of-file markers and records are delimited by their constant length, relative positions in the file, and the total length of the files. DOS random and DOS random type 2 files are identical, except for the way in which the signs are represented for packed decimal and zoned decimal numbers.

 900 pts.

 

When you define the data transfer, press the [Details...] button, then in the “Output PC file” group press the [Details] button (next to the File type drop-down menu) and unmark the “Include end of file indicator” check box.

That’s it, good luck.

Gerardo

 300 pts.