Posted: Tue Jan 12, 2016 4:00 am Post subject: Alignment of records in SFTP from one Mainframe to other
Hi,
When I'm doing SFTP from 1 Mainframe to other, JCL is running fine and data is received on Destination server, But problem is alignment of records.
Records are overlapping in the output file.
Below is the DS (records) I want to send.
Code:
DFX12345Bout of hour week day 00000001000.00000002000.0017
DFV17911NCERT COMP,ASM,TUBE,X-RAY GEN,NO 00000000000.00000071161.1100
DFV98765ANormal Hour 00000000255.00000000255.0000
DFV17911NCERT COMP,ASM,TUBE,X-RAY GEN,NO 00000000000.00000071161.1100
DFV95864ANormal Hour 00000000255.00000000255.0000
On Destination side it is receiving as below .
Code:
DFX12345Bout of hour week day 00000001000.00000002000.0017.00000.00…DFV179
11NCERT COMP,ASM,TUBE,X-RAY GEN,NO 00000000000.00000071161.1100.00020.00…DFV98765A
Normal Hour 00000000255.00000000255.0000.00000.00…DFV17911NCERT C
OMP,ASM,TUBE,X-RAY GEN,NO 00000000000.00000071161.1100.00020.00…DFV95864ANormal Hour
00000000255.00000000255.0000
Can any one please provide JCL for SFTP transfer from one mainframe to another with exact alignment of DATA records as in Source file .
Joined: 01 Feb 2007 Posts: 1075 Topics: 7 Location: At Home
Posted: Tue Jan 12, 2016 9:54 am Post subject:
What end-of-record character are you using on the Unix side? What are your control cards for sending to the mainframe - including defaut options? _________________ Utility and Program control cards are NOT, repeat NOT, JCL.
Joined: 26 Nov 2002 Posts: 12359 Topics: 75 Location: San Jose
Posted: Tue Jan 12, 2016 10:14 am Post subject:
Vinay Kumar M,
On most ASCII UNIX system, the end-of-line character is a single LF (LineFeed) or 0x0A. On Windows, the normal end-of-line is a 0x0D0A (CRLF or CarriageReturn-LineFeed).
You can try using BINARY format in FTP and if that does not work then you can use CRNL option which causes all sequential output files created by A-Shell to have CRLF terminators instead of the UNIX-standard LF terminators.
Code:
cp -F crnl unixfile.txt "//'ftpdataset.txt'"
_________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum