To retrieve data from a remote system

pts.
Tags:
390
Application development
AS/400
AS/400 careers
Backup & recovery
Billing and customer care
Billing Support Systems
CLP
DataCenter
DB2
DB2 Universal Database
Development
Email
IBM Marketing Sound Off
Mainframe
Mobile
Mobile security
Network protocols
PC/Windows Connectivity
Printing
RPG
RPGLE
Security
VoIP
Web development
Wireless
zSeries
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either as the cost is not justifiable for our case. Any suggestion regarding would be of great help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well.

I keep meaning to “have a go” with socket programming and have seen a lot of good press on Scott Klement’s tutorial at http://www.scottklement.com/rpg/socktut/index.html

Hope it helps

Jonathan

================================================

Since there have been no useful responses yet, I’ll add another useless one.

<ol>
<li>You need to transfer data to your AS/400.</li><li>You don’t know what you’ll be transferring from; it’s likely to be different on a regular basis.</li><li>You can’t use the only known way to transfer data between different and unknown platforms, i.e., FTP.</li>
</ol>

I don’t know why you can’t use FTP. If your boss has dictated it, then tell his/her boss that your boss is nuts and needs to be replaced. Giving you a task and simultaneously restricting you from using the only known method of doing the task is nuts.

Tom

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Seconddan
    One solution I used at a previous (cheap) employer was to put a Wintel machine between the source and destination. After mapping drives onto both boxes (UNIX and iSeries IFS) a Windows scheduled script copied files between the two drives.
    0 pointsBadges:
    report
  • SteveRG
    Why don't you try TFTP and shell scripting for automation?
    0 pointsBadges:
    report
  • WebSphere24X7
    You could use RFROMPCB.EXE - Batch transfer from the PC to OS/400, which is part of iSeries Access for Windows.
    0 pointsBadges:
    report
  • Jay400
    You can do the following without spending any money. Setup NFS (Network File System) where AS/400 is the client and the other system is the server. Ask the Other System Admin to export the path of the remote data to your AS/400, and you mount that path over an IFS directory on AS/400. Use cmd DSPUSRPRF to get the UID of the user under which you will run your unattended batch job that copies data from the remote system, and tell your Other Sys Admin to set this UID as the owner of everything under that exported path. Setting up owner is done during the export process. Once you mount the remote path (cmd: MOUNT) your batch job and the authorized users will access the remote data from your mounted IFS directory. I hope this helps. - Jay
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following