MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Alignment of records in SFTP from one Mainframe to other

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
Vinay Kumar M
Beginner


Joined: 02 Jun 2015
Posts: 12
Topics: 6

PostPosted: Tue Jan 12, 2016 4:00 am    Post subject: Alignment of records in SFTP from one Mainframe to other Reply with quote

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 .
Back to top
View user's profile Send private message
Vinay Kumar M
Beginner


Joined: 02 Jun 2015
Posts: 12
Topics: 6

PostPosted: Tue Jan 12, 2016 4:13 am    Post subject: Small correction Reply with quote

We are sending data from Unix server to Mainframe server (Not from Mainframe to mainframe).

I need what changes to be done in Unix end so that Content of received DS alignment in Mainframe end to be same as of file sent from Unix end.

Below is line currently we are using at the UNIX end to transfer file


Code:

Put filename  /-/mainframe dataset name



When we use this, alignment was not proper as i have shown in previous post code snippet.

So please suggest what changes to be done on Unix end code, So that We receive properly aligned DS on Mainframe end.

Thank you
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Tue Jan 12, 2016 9:54 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Tue Jan 12, 2016 10:14 am    Post subject: Reply with quote

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

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
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


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group