RE: Library List used by FTP job

["Holder, Ken" <kkh@xxxxxxxxxxxxx>]

We do some similar FTP jobs on our system.  We break it down into smaller 
parts.  We FTP the file to a secured landing library first.  Then we have the 
FTP script run a remote command that starts a job schedule (JS) job.  The JS 
job sets the library list and has enough authority to copy all the records into 
the production table.  Your tigger would run at the time the records are copied 
in the production table. 

One note on the JS job. We actually run two JS jobs.  The first one can be 
started from the FTP script and the user profile that is FTPing the file has 
authority to run the job..  The second runs as a result of the first JS 
completes normally using a dependence.  This way security is not an issue.

Hope this helps and I'm sure there are other methods of accomplishing the same 
results.

Ken H.


-----Original Message-----
From: midrange-l-bounces+kkh=nwnatural.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+kkh=nwnatural.com@xxxxxxxxxxxx]On Behalf Of
Doug_McLauchlan@xxxxxxxxxx
Sent: Wednesday, November 02, 2005 4:00 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Library List used by FTP job


I am attempting to FTP some data to a table on our iSeries using a 
specific USERID to make the connection.

The table has an *AFTER *INSERT trigger which calls a series of programs 
to process the data.

I keep getting an error that the programs called by the trigger program 
cannot be found in the library list of the FTP job.

USERID has a specific JOBD that includes all the necessary libraries, but 
the FTP job seems determined not to look at that, but use the library list 
from the QTCP user.

I don't want to change the QTCP JOBD as this is not environment specific - 
I need to be able to send the data to TEST / PROD etc.


How do I make the FTP job use the libraries specified for my USERID rather 
than QTCP ?


Thanks.


Doug McLauchlan

Planar Systems, Inc.


______________________________________________________________________
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email  Content Service, visit http://www.mci.com.
______________________________________________________________________