Need help transfering iSeries DB2 file to PGP Windows program
Home > IT Answers > AS/400 > Need help transfering iSeries DB2 file to PGP...
MichelleDavidson
110 pts.
0
Q:
Need help transfering iSeries DB2 file to PGP Windows program
AS/400, RPG, TCP
Augusto needs your help. He writes:

"I have an RPG ILE program that creates a file in my iSeries. The CL I am running controls that the file is ready to FTP to another location. To do this I have to transfer the file to a PC/Windows environment and then use a Windows-based PGP encryption program, which is the requirements at our company.

"I tried different methods to not use an operator after the file is ready to be tranfer to the Windows environment, but they did not work. Could you please give an idea how can I use just one CL program or an RPG-ILE to submit this file to a Windows environment and then transmit it with the PGP encryption program based in the same Windows environment? Thanks much in advance for your help."
ASKED: Aug 16 2005  9:42 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
KeithHodges
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
There are 2 canned packages I know of that do this, by Linoma and by Patrick Townsend, and probably others. To get by on a budget, you could use the PGP-compatible freeware known as GPG (www.gpg.org).
I've written code that would do this in the past. My solution works with GPG, but if you already have PGP, it could easily be adapted to work with PGP.
Last Answered: Aug 16 2005  10:33 AM GMT by KeithHodges   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

BigKat   2540 pts.  |   Aug 17 2005  8:37AM GMT

If you have an FTP server on the PC, you could have the iSeries CL FTP the file to the PC and then send a remote command to run a .BAT file on the PC to do your PGP processing. Look at help for quote and rcmd to see how you would send the remote command.

 

McSick   30 pts.  |   Aug 17 2005  9:44PM GMT

Use CPYTOIMPF to create a comma delimited version of your file and copy to /QDLS/…. then FTP /QDLS/… .csv file to PC network folder

Or

Use CPYTOSTMF command to copy the fixed file to /QDLS/… .dat or .txt file and then FTP /QDLS/… .dat or .txt file to PC network folder

 

TomLiotta   7285 pts.  |   Nov 1 2009  7:31AM GMT

Note that any references to [/QDLS] should be taken to mean [/QNTC]. The /QDLS file system should not be used on any system at V5R1 or later.

The /QNTC file system is a meaningful replacement choice because it automatically refers to shares that have been exported from Windows server systems. A more complete path would be [/QNTC/windowsservername/sharename/RemoteFileName.ext]. There is no need for FTP. The remote PC is written to directly.

A requirement is matching user/password on both systems. The user/password on the Windows system is often created as a local user on that PC. The System i user can be created just for the purpose of transfers to/from Windows. Security APIs can be used to switch the job to the transfer user before the transfer, and then back to the job user after completion. The transfer itself would be essentially transparent.

Tom

 
0