Looking for files on a Windows server via a CL programme

Admin Rookie

unread,

Nov 25, 2009, 7:23:49 AM11/25/09

to

Hello,

I work for a retail company and we 'poll' our sales from our EPOS
system to a Windows server on our network. The polled 'sales file' is
then sent to my iSeries using a windows scheduled task, which moves
this file to a mapped drive, the mapped drive being a share in the
iSeries IFS. From there we run our overnight jobs etc.

My problem is that the Windows scheduled task is unreliable and
sometimes doesn't run. There is no apparent reason why and the
following days it runs fine. As these sales files are the lifeblood of
my employer, I'm looking to see if i can do it the other way around,
that is to get my iSeries to look to the windows server and fetch the
file itself.

Does anyone know if this is possible using some CL or by any other
means? I'm not too familiar with RPG so i would like to avoid that.

As always, any help appreciated.

iseriesflorida

unread,

Nov 25, 2009, 8:16:16 AM11/25/09

to

What if you use FTP to go get the file via the 400 and then use OS400
job scheduler. You could do this using CL programs.

Marc Rauzier

unread,

Nov 25, 2009, 8:50:47 AM11/25/09

to

Admin Rookie �crivait dans
news:2304896f-7b21-462c...@j14g2000yqm.googlegroups.co
m ce qui suit:

> Hello,

Hello

You could instal iSeries Access on the Windows server, activate
"incoming remote command" in order for your iSeries to run any Windows
command or cmd file.
With this method, the iSeries controls scheduling the transfer from
Windows server to the mapped drive, through RUNRMTCMD.

More information here:

http://www-
912.ibm.com/s_dir/slkbase.NSF/wca?OpenView&Start=1&Count=30&Expand=7.1#
7.1

(http://tinyurl.com/yzbxzqz)

>
> As always, any help appreciated.

--
Cordialement
Marc Rauzier
(pour me r�pondre, ne pas utiliser le from mais le reply-to)

Admin Rookie

unread,

Nov 25, 2009, 9:14:13 AM11/25/09

to

Hi,

I'm going to try both of these. Good suggestions. Many thanks for your
feedback!

Mark

unread,

Nov 25, 2009, 12:05:17 PM11/25/09

to

On Wed, 25 Nov 2009 04:23:49 -0800 (PST), Admin Rookie <paul.m...@gmail.com> wrote:

>Does anyone know if this is possible using some CL or by any other
>means? I'm not too familiar with RPG so i would like to avoid that.
>

Third option is QNTC. This is the same as your current IFS solution but taking the file
directly from the Windows server:

/QNTC/Server Name/Share Name/Filder Name/File

Preferably the iSeries should be in the same domain as the Windows Server (or other
considerations will apply), and the user running the iSeries job must have authority to
the Windows Server (i.e. it must match a corresponding Windows user account with the same
password).

If you can see the file using WRKLNK there should be no problem.

--
Mark

Richard Schoen

unread,

Dec 21, 2009, 11:07:47 PM12/21/09

to

We have a product called IFSTools which allows you to send/receive IFS files
from/to any Windows based server share.

Feel free to contact me directly or ask our sale team about downloading a 30
day demo.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: ric...@rjssoftware.com
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

"Admin Rookie" <paul.m...@gmail.com> wrote in message
news:2304896f-7b21-462c...@j14g2000yqm.googlegroups.com...