Ron Thomas, Did you check if you have enough disk space on virtual machine ? you might have gotten an error message that about the transfer aborting due to disk overflow. So unless you paid attention to the error messages you will be left with partial data on the virtual machine.
Did you look at the job logs from SFTP and see if there are any error messages? Do you have matching DCB properties on SITE command to match the excel file properties? >>And last but not least, z/OS FTP's processing of concatenated data sets. If any data set in the concatenation is empty, FTP stops and gives a CC=0. Richard, You can use the "Append" to avoid the problem with empty datasets in the concatenation list. Something like this. Refer each dataset with a DDname and use APPEND //INFILE1 DD DSN=USERID.FILE1,DISP=SHR //INFILE2 DD DSN=USERID.FILE2,DISP=SHR //INFILE3 DD DSN=USERID.FILE3,DISP=SHR //SYSIN DD * put //DD:INFILE1 remote.file append //DD:INFILE2 remote.file append //DD:INFILE3 remote.file Thanks, Kolusu From: Ron Thomas <[email protected]> To: [email protected] Date: 04/03/2017 03:16 PM Subject: SFTP issue Sent by: IBM Mainframe Discussion List <[email protected]> Hi . We have customer users uploading sales data in excel format in a portal, once this file is uploaded a batch process will SFTP the file from here to a virtual machine and then to the mainframe . We are seeing that there are many cases where all the rows the user entered in excel file is not getting transmitted to virtual machine . How we can make sure that all the rows gets transmitted to virtual machine , if all the rows gets transmitted then only transmit to mainframe else ? is there any specific design considerations we need to follow ? Please suggest valuable thoughts on this ? Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
