Re: Interfaces in PeopleSoft.

[the dragon <ceprn@HOTMAIL.COM>]

Scott,

You could do that (write an sqr), but it seems like a lot more work that
using the tools that are supplied to you with AIX on your RS6000.

Use a Unix shell script (about 100 lines of code, including documentation
comments) - you can write it, cron the job and be done with it forever.

clark 'the dragon' willis
dragon enterprises, consluting services.

----Original Message Follows----

I want to automate an interface.

Background
I have GL data (Journals) coming to me from an AS/400 and then loaded into
our RS/6000 running AIX.  I have an SQR the pre-process the AS/400 file to
create a file that PS provided GLS9002.SQR can then load into peoplesoft.

I have been asked to automate the process. Like this, the only thing that
the User does is kick off the process on the AS/400, which then ftp's the
finished file to the RS/6000 , which then runs the preprocess, renames the
AS/400 file ,emails the user the hash totals report, then runs GLS9002, and
then notifies the user that the entire process is complete.

I was thinking about creating an SQR to run the preprocess, rename the
files, email the user w/ the hash totals, and excute GLS9002. Will this
work?  Would it be worth the over head to get some kind of daemon set up on
the RS/6000 that monitors the ftp directory and then kicks off the whole
shebang.  OR should I do all of this with a Unix Script.

  Had anyone done this? Do you have sample scripts or SQR's with any single
part of this.  I am willing to put all this back together and then post it
here if you guys would like, I just need an idea of the best approach.


Thanks
Scott

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