Automatic Data transfers from iseries

230 pts.
Tags:
IBM iSeries
iSeries Data Transfer
I am quite ok with manual data transfers and menu options calling transfers, but does anyone know how to get a data transfer set up from the iseries to a mapped drive on our server to run automatically, e.g. at 04:30 am ?

Also, is it possible to send data from the iseries to a server that is not on my network?

We have a new parent company and they want a daily data transfer done, without adding us to their network - I know !!

Many Thanks



Software/Hardware used:
iseries, OS/400 r5v4, windows 2003 server

Answer Wiki

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

Anything you are doing manually on the iSeries, you can do autmatically by writing a CL program and putting scheduling that job to run automatically.
With FTP, you put the spec’s in a source member and do an OVRDBF
Here is a sample
CRTPF FILE(QTEMP/FTPIN) RCDLEN(80)
CRTPF FILE(QTEMP/FTPOUT RCDLEN(80)
OVRDBF FILE(INPUT) TOFILE(QTEMP/FTPIN)
OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPOUT)
FTP RMTSYS(&HOST) /* &Host is a variable from one of our tables */

Discuss This Question: 8  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
  • TomLiotta
    ...a data transfer set up from the iseries to a mapped drive on our server... That could simply be a scheduled CPY command that ran under a profile that had permissions to the share. The share could be addressed as '/QNTC/servername/sharename/target.file'. ...is it possible to send data from the iseries to a server that is not on my network? That's a little harder to guess. What kind of server? The FTP option is good if an FTP server is running. Depending on how server authentication/authorization is set up, it might still be possible to go through /QNTC. When it's possible, you can often use the IP address instead of a server name:
    CPY ... TOOBJ('/QNTC/xxx.xxx.xxx.xxx/sharename/target.file') ...
    If that can't be used, I'd go with NFS. A NFS server needs to be running on the other end. If one's available there, that's as good of a choice as any. Can you show a couple examples of the first data transfer? And can you tell what the remote "server" is? Tom
    125,585 pointsBadges:
    report
  • KasMcc
    Many thanks for your replies I am yet to discover the kind of server that out new bosses have at their site, but I will experiment with our server here to see if I can provide the information they want Thankyou K
    230 pointsBadges:
    report
  • HaraldvK
    An alternative... I do not know whether it is available on an iSeries, but there are tools that let you create an email with attachment to send to any email-address. Maybe that is an option you can think about. I know of it being used on a zSeries, the utility is called XMITIP, which is freeware!.
    55 pointsBadges:
    report
  • Teandy
    I do not know whether it is available on an iSeries, but there are tools that let you create an email with attachment to send to any email-address. Maybe that is an option you can think about. I know of it being used on a zSeries, the utility is called XMITIP, which is freeware!. There are several. Some are free and some are commercial. MMAIL and RPGMAIL are two free ones that I know of. MAILTOOL by Brad Stone is a commercial program that we use.
    5,860 pointsBadges:
    report
  • TomLiotta
    I am yet to discover the kind of server that out new bosses have at their site Can you start a FTP session to it? The FTP reply messages might give a clue. Tom
    125,585 pointsBadges:
    report
  • KasMcc
    Despite many weeks of wrangling with the new IT department, they are very reluctant to let me in on the secret of the server set-up. They have decided to put an IP-sec line into our main site, so we should be able to do a reasonably straight forward data transfer once this is up and running. Thanks to all for your advice
    230 pointsBadges:
    report
  • TomLiotta
    They want you to transfer data to some system without even knowing what it is? Without knowing if it runs a ftp server? ...if it supports NFS? ...if it supports Windows networking (Samba, SMB)? I assume they will at least provide a userid & password or some other means of authentication...? An IP address...? Tom
    125,585 pointsBadges:
    report
  • KasMcc
    Thanks for all the advice. I've told the new bosses that they need to gove me all the information I require to access their system and left it at that. I'm sure at some point, they may realise that you cant data transfer unless you know what you are transferring to
    230 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