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






