PGP in SQR

[belindadeg]

Does anyone have an example of calling pgp from an SQR. We cannot seem to get the direct call to work. If we have the SQR create a .bat file then execute the .bat file, it works fine.

The problem is this requires manual intervention. We want to call PGP directly from SQR. This is the code we have:

let $pgpcmd = 'pgp --encrypt ' || $filename_with_path || ' --r ' || &pf.oprid || ' --passphrase ' || &pf.operpswd || ' --text --overwrite remove'

call system using $pgpcmd #status

The .bat file works fine. This is the .bat:
c:
pgp --encrypt \\Intranet\dfs-amer\Group\Nyk\HR\PeopleSoft8\hr88sp1\install\sqr\Output\eWorkforceTimeEntry_04022007.txt --r prodops --text --overwrite remove
echo completed the transfer > \\INTRANET\DFS-AMER\GROUP\Nyk\HR\PeopleSoft8\hr88sp1\install\sqr\output\2084.txt
ftp -s:\\INTRANET\DFS-AMER\GROUP\Nyk\HR\PeopleSoft8\hr88sp1\install\sqr\output\2084.scr


Any help would be greatly appreciated.

[wharri]

If you don't have any luck with PGP, try GnuPG. It is not as friendly but the command line execution works.

[stmcgarret]

At what point are you required to provide manual intervention for your Call System code? Or, is the Call System code simply not working and it is the .bat file that requires manual intervention? If yes to this, what is the error you receive on Call System?

We successfully do the exact same thing except with UNIX by calling a ksh script. Here, we pass in the parms to the script via a .dat file which is read in by the script when it first starts. As far as the passphrase where you have --passphrase, we use a Public key off of a keyring.

[PSSG]

I need to do the exact same thing with PGP and FTPs please help me if you are able to encrypt the file and ftp it on NT server. Thank you