Automatic Data transfers from iseries
120 pts.
0
Q:
Automatic Data transfers from iseries
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
ASKED: Oct 13 2009  3:19 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
6540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 */
Last Answered: Oct 13 2009  3:32 PM GMT by CharlieBrowne   6540 pts.
Latest Contributors: Aceofdelts   410 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

TomLiotta   8000 pts.  |   Oct 13 2009  10:36PM GMT

…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

 

KasMcc   120 pts.  |   Oct 14 2009  8:12AM GMT

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

 

HaraldvK   55 pts.  |   Oct 14 2009  8:17AM GMT

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!.

 

Teandy   3250 pts.  |   Oct 14 2009  6:27PM GMT

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.

 

TomLiotta   8000 pts.  |   Oct 14 2009  11:04PM GMT

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

 

KasMcc   120 pts.  |   Oct 27 2009  2:59PM GMT

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

 

TomLiotta   8000 pts.  |   Oct 27 2009  11:43PM GMT

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

 

KasMcc   120 pts.  |   Nov 11 2009  4:26PM GMT

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

 
0