FTP through CLP program
55 pts.
0
Q:
FTP through CLP program
Hello,

I have a script written for 'INPUT' file during the FTP process. The user-id and the password are being hardcoded in the script.To maintain the security I want to encrypt the password alone in the script.May be when the FTP is in action, the password can be retrieved from a file or data area etc. Overall - Hard coding the password in the script needs to be avoided.

Awaiting for your help and thanks in advance.
ASKED: Oct 1 2009  5:45 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
2005 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi,

What we do is taking the User and PW from a file (or DtaAra) and putting it on the script "on the fly" and after finished the transfer, cleaning the line (in the script).

Wilson
Last Answered: Oct 1 2009  6:53 PM GMT by WilsonAlano   2005 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Sris1986   55 pts.  |   Oct 1 2009  7:31PM GMT

Thanks for your response Wilson..

Can you pls share me the actual script statements used to assign the password to the user on fly?
I mean the statements in the scripts used to fetch the password from data area/physical file?

 

WilsonAlano   2005 pts.  |   Oct 2 2009  2:12PM GMT

Hi,

We use a RPGLE program to read the INPUT file, find the first line and replace/put password on it.

 

TomLiotta   7295 pts.  |   Oct 8 2009  8:07PM GMT

A basic SQL UPDATE statement can update a row in a script/table. The row may consist of a single field with a constant value such as ‘PASSWORD’. Copy the script to QTEMP, update the row, execute the OVRDBF to point to your QTEMP version and execute FTP. Delete the QTEMP script.

The file is essentially protected while it resides in QTEMP. Even if the job fails and doesn’t delete the file, QTEMP will go away anyway.

Tom

 
0