|
View previous topic :: View next topic
|
| Author |
Message |
shalva.krish
New User
Joined: 30 Aug 2023
Posts: 3
Location: USA
|
|
|
|
Hi ,
We are currently having FTP where we transfer FTP to SFTP. As part of testing, we processed SFTP job to post the mainframe file to AWS. Job went fine and file posted to AWS. But when we open the file, we can see junk ‘#’ character at the end of each line.
Then we used same mainframe file, posted to AWS using ftp job and that file is not having any junk character.
We validated mainframe file with Hex on - no junk character
we validated the OMVS file with Hex on - No Junk character
we validated the file in AWS after the transfer using SFTP - shows # junk character at the end of each record . While researching I found
this link
community.sap.com/t5/application-development-discussions/how-to-remove-symbol-output-inbound-file-from-sftp-with-write-statement/m-p/12063048
Do SAP has to put any notes for this issue ? Please advise |
|
| Back to top |
|
 |
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
|
|
Are you sending from Mainframe dataset to USS(OMVS) and from OMVS to AWS?
What product are you using to send from USS to AWS?
FTPS or SFTP? - Names may look same, but different.
Show the statements used in the transfer?
The problem is most likely CR LF - EOL characters being messed up in different platforms. To indicate End of a record, Mainframe user CR, Windows has CR LF, Unix has LF.
One other suggestion would be to look at the file in Mainframe with HEX ON, then note down the HEX values of 2 records.
Then look how the file looks in OMVS, with HEX ON and note down the HEX values.
Then look at the file in AWS, NOTEPAD++ has a plugin to view the HEX values.
With these steps you can confirm if it's related to CR LF translation, which it most likely is. |
|
| Back to top |
|
|
shalva.krish
New User
Joined: 30 Aug 2023
Posts: 3
Location: USA
|
|
|
|
Are you sending from Mainframe dataset to USS(OMVS) and from OMVS to AWS? - Yes using SFTP
we tried using EOL=nl and EOL=not .
For both options it is working without the # character .
Thanks for your help |
|
| Back to top |
|
|
|
|
