Data Transfer from AS/400

[ymchou]

Hi List,

Every month I need to download a number Fastr Reports to PC.

Currently, I'm doing the transfer report by report (using Client Access).
But this is tedious.

I am wondering whether it is possible to set up a sort of scheduling or
maybe even write a CL to automated the data transfer so that it will run
automatically at nite (like a sleeper job).

Any idea whether this is possible? If yes, how do I set it up?

Thanks alot.

Regards,

May


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 

[DBelcher]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07B03.1237F7B0
Content-Type: text/plain;
charset="iso-8859-1"

May,

You probably would want to look into some type of 3rd party software, i.e.
something like RJS Software, Monarch, etc.. As far as I know there is no
way to do this with native World programs.

Doug Belcher
KV Pharmaceutical
St Louis MO
Opinions expressed are not necessarily those of my employer


>

Doug Belcher
St Louis MO
Opinions expressed are not necessarily those of my employer

 

[m_agarwal]

Hi May

As you siad the FASTR can be run as sleeper jobs. However to do a transfer
automatically, there are two options:
1. AS/400 supports automated FTP as a sleeper job. See AS/400 help on FTP.
With this the files can be downloaded to a PC with a specified IP address.
2. A program can be writen in Visual Foxpro or Visual Basic which can be run
in a shceduler. The program launches by itself, uses ODBC to connect to
AS/400 and downloads the files.
We are regualrly using the second approach.

Regards

Manish Agarwal
Castrol India Ltd.
----- Original Message -----
From: "ymchou" <[email protected]>
To: <[email protected]>
Sent: Wednesday, January 10, 2001 12:10 PM
Subject: Data Transfer from AS/400 ~~0:3630


> Hi List,
>
> Every month I need to download a number Fastr Reports to PC.
>
> Currently, I'm doing the transfer report by report (using Client Access).
> But this is tedious.
>
> I am wondering whether it is possible to set up a sort of scheduling or
> maybe even write a CL to automated the data transfer so that it will run
> automatically at nite (like a sleeper job).
>
> Any idea whether this is possible? If yes, how do I set it up?
>
> Thanks alot.
>
> Regards,
>
> May
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3
630
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>

 

[dale_draper]

You could set up a CPYTOSTMF and FTP the resulting file to an NT server.

Scheduling a connection to the AS400 is the tricky part of what you are
proposing. C/A's help show how to make a .bat file that you can schedule to
run from your NT server or use the AS400's remote PC command and schedule
that. But again, scheduling the connection NT to AS400 becomes an issue.
Either way, we're talking about 2-3 hours of set up (or more) depending on
your expertise when it take you 10 seconds of tedium to start the C/A
transfer only once a month. I don't see much of a gain there for the effort.


That said, using ODBC in Excel and setting up a template would be a good
solution as well, assuming the format stays exactly the same each month.


>

 

[deanna_vaughn]

If you do become interested in a 3rd party software, check out Compleo by
Symtrax. We download all of our FASTR financials at monthend. Works
extremely well.
Deanna Vaughn
IHS Energy Group
(303) 736-3123
7.3 Cume 11 V4R4


>From: DBelcher <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: RE: Data Transfer from AS/400 ~~3630:3641
>Date: Wed, 10 Jan 2001 04:44:49 -0800 (PST)
>
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>
>------_=_NextPart_001_01C07B03.1237F7B0
>Content-Type: text/plain;
> charset="iso-8859-1"
>
>May,
>
>You probably would want to look into some type of 3rd party software, i.e.
>something like RJS Software, Monarch, etc.. As far as I know there is no
>way to do this with native World programs.
>
>Doug Belcher
>KV Pharmaceutical
>St Louis MO
>Opinions expressed are not necessarily those of my employer
>
>
> >
>
>Doug Belcher
>St Louis MO
>Opinions expressed are not necessarily those of my employer
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3641
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

 

[mike_morgan]

What you are looking for can be accomplished with a CL program. You need
someone who understands CL programming. I am a programmer and have done
this very task many times. If you would like some help with it, please
contact me at:

Michael H. Morgan
Director of Consulting
DataPark Inc.

Office - (817)379-8593
Mobile - (972)740-3999

[email protected]

 

[Ernest_Givens]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01C07B27.D1364670
Content-Type: text/plain;
charset="iso-8859-1"

Hello May, found this link in the IBM knowledge base. I'm not sure which
version of Windows your running, this resolution applies to Windows NT/2000,
hope it helps you...

Ernest Givens
AS/400 Systems Administrator
SCB Enterprise Solutions
480-539-2224