Hi Laura,
If you haven't already found a solution, open the .csv file in Notepad++.
Select the View Menu and Show Symbols. Select the Show End of Line option
to confirm the End of Line Character.
Then on the CPYFRMIMPF Command specify the End of Line character in the
RCDDLM Record Delimiter parameter.
I recently started receiving a .csv file where the End of Line Character
just the LF Line Feed Character.
Hope that helps,
Michael
Sent: Tuesday, December 03, 2024 at 5:11 PM
From: "ubelhor@xxxxxxxxxxxxx" <ubelhor@xxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: "Mike Baker" <mbaker@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Concur AP
Hello:
Has anyone worked with Concur AP interface between IBM i and Concur
system?
We are able to send files to Concur in csv format without issue but are
having issues when Concur sends the csv format file to the IFS. When we
use CPYFRMIMPF command to move from the IFS to DB2 some of the records are
dropped. We are thinking it may be a carriage return but aren't certain.
I thought that I would reach out and see if anyone else has had and
addressed the same issue. We have chaged CCSID to no avail.
We'll look forward to your replies and insight.
Regards,Laura
Laura A. UbelhorPresidentConsultech Services,
Inc.[1]www.consultechservicesinc.com
phone 248-701-7410
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [2]
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [3]
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
References
Visible links
1.
http://www.consultechservicesinc.com/
2.
https://lists.midrange.com/mailman/listinfo/midrange-l
3.
https://archive.midrange.com/midrange-l
midrange.com
