After replacing the FTP scripts with SFTP, and adding CPYFRMIMPF, I discovered an issue, which still puzzles me.
It's not clear how and why the i5 system, user, password may OR may not be cached on the PC.
From a PC, when running RMTCMD CPYFROMIMPT is resulting in error depending on the user.
1) Successful for me.
2) Coworker results to different and incorrect LPAR - error.
3) User results to correct LPAR but wrong IP - error.
Can anyone explain this?
FTP allowed a remote command from within the FTP script, SFTP does not.
When RMTCMD is used in an FTP script, it only needs the command, system, user, password is shared/within the FTP script.
When RMTCMD is used in a bat file, it requires command, system, user, password.
When RMTCMD is used in a bat file, it may work correctly without system, user, password, if cached from a previous process.
To ensure RMTCMD system accuracy, need to add the system after the remote command.
To ensure RMTCMD user accuracy, need to add CWBLOGON prior to the RMTCMD.
Following the RMTCMD, CWBLOGON with a clear should be called.
WinSCP.com /console /script=SENDPTC.scp /log=SENDPTCLOG /ini=nul
CWBLOGON x.x.x.x /u user /p password
rmtcmd CPYFRMIMPF FROMSTMF('/PTC/LOCKBOX/LOCKBOX.LKB') TOFILE(CMFILES/LOCKBOX) MBROPT(*REPLACE) RCDDLM(*LF) //x.x.x.x
CWBLOGON x.x.x.x /u user /C
Pause
Are there other options?
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Sunday, May 07, 2017 12:28 AM
To: Midrange Systems Technical Discussion
Subject: Re: Replacing FTP PC client scripts to SFTP to put PC file to a i5 library.
Paul,
OpenSSH (the software package that IBM provides to act as a client/server for SSH, SCP and SFTP) is a Unix program. It is written for Unix and runs in PASE.
It has no notion of a "library" (which is a bizarre concept that doesn't exist on other systems, including Unix.) It does not know anything about physical files.
So, I would suggest that you transfer your data to the IFS, and then if you really need it in a PF, use something like CPYFRMIMPF or CPYFRMSTMF to convert it to a PF.
-SK
On 5/6/17 9:16 PM, Steinmetz, Paul wrote:
I need to replace all our FTP PC client scripts to SFTP.
I'm testing with WINSCP.
SFTP script is working, but only to IFS.
1) I'm struggling to find the option so the file will be sent to a library.
Cd /pauls - result in IFS
Cld - invalid command
2) I would also like to show the SFTP transfer as FTP did.
The person running the script can confirm if the file was sent successfully.
SENDCABLE.bat
WinSCP.exe /script=SENDBRC.scp /log=SENDBRCLOG /ini=nul pause
SNDBRC.scp
open sftp://user:password@hostname/ -hostkey=* cd /pauls put
-transfer=ascii c:\lockbox\brc\lkbpcs.lkb
Any thoughts from the group.
I will be evaluating other script options.
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://www.pencor.com/
--
Scott Klement
http://www.scottklement.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
