[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Unable to do a SFTP to a secure server
- Subject: [sqr-users] Unable to do a SFTP to a secure server
- From: Robin_Ferebee@nexnet.navy.mil
- Date: Thu, 1 Dec 2005 07:46:41 -0500
- Delivery-date: Thu, 01 Dec 2005 08:49:17 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Good morning. I am attempting to FTP a file from my PeopleSoft unix
server to a secure unix server. I created a batchfile, but I'm not sure
how to execute the command to ftp. Here is my code:
Open $ScriptFile as 1 For-Writing Record=800 Status=#Open1
Let $ScriptData = 'user xxxx yyyyy' !Production
Write 1 from $ScriptData
Let $ScriptData = 'lcd '||$Unix_dir
Write 1 from $ScriptData
Let $ScriptData = 'cd '||$Merch_Path
Write 1 from $ScriptData
Let $ScriptData = 'user ssh xxxxxx yyyyyy'
Write 1 from $ScriptData
Let $ScriptData = 'sftp merch@merchweb1'
Write 1 from $ScriptData
Let $ScriptData = 'eat34bugs2day'
Write 1 from $ScriptData
Let $ScriptData = 'put ' || $filename||' '|| $filename
Write 1 from $ScriptData
Let $ScriptData = 'quit'
Write 1 from $ScriptData
Let $ScriptData = 'exit'
Write 1 from $ScriptData
Close 1
Let $BatchExec = 'sftp '|| '-B hqsun4 <' ||$ScriptFile ||'> ' ||
$ScriptLog {This line creates the error}
Let $CommandString = $BatchExec
Call System Using $CommandString #Status Wait
Thanks.
Robin S. Ferebee
Application Developer
Programming & Development Group
Navy Exchange Service Command
(757) 631-3347
***************************defiant************************************
This email and any files transmitted with it are intended solely for
the use of the individual or agency to whom they are addressed. If
you have received this email in error please notify the Navy Exchange
Service Command e-mail administrator.
This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
messaging_support_team@nexnet.navy.mil
**********************************************************************
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users