Hi ,
We have PF which having carraige return character.
Due to this when i am trying to export the file in .csv format using CPYTOIMPF , that particular record is getting splitted into two.
How to remove these carraige return characters....
4 results in 0.0016 seconds.
-
How to remove Carriage return character from PF
-
Error when using CPYTOIMPF command
Hi all,
I am trying to move one logical file data int flat file using command CPYTOIMPF but i am getting error.
Any idea why this error is coming? I attached the error screen shot. Also whats the alternate way of downloading the data.
Regards,
... -
CPYTOIMPF leaving out records
I'm trying to use CPYTOIMPF to extract the data in my table to a tab delimited text file. It seems to work okay, except that it keeps leaving out the last 2-3 records. Any ideas on why this might be happening? The command and parameters I'm using are below.
...Code:CPYTOIMPF FROMFILE(QTEMP/CUSTSEGH)
-
How to convert as400 data fl to .xls file
Hi Everyone,
I have been sucessful converting both flat files(sys/36 files) and external described files to .csv files and then sending them to various sites via email or FTP using commands in a CL program. Some sites require "true" .xls files. I know that there is software that can...