× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



> Am I right in thinking that the FTP job started for the
> connection will
> end after the connection is complete ? It appears that way
> from my recent
> tests, but I'm no expert on this.

The FTP server job is an OS/400 Pre-start job that can be re-used by up
to 200 users (200 hundred is the factory shipped default) before it is
ended.  So you will be changing the library list for all users of that
job.

One way to manage your library within a program (Some of the better
programmers on the list may have easier/better ways to do the same
thing) is to use the Program Status Data Structure to determine what
library the program is called from.  Then you can use this library name
to determine which library(ies) to look to for the data.  By putting the
library name in a program variable, you can then make qualified
references to the data, and then (bonus!) worry less about a test
program accidentally updating production data. 

HTH,

jte



--
John Earl | Chief Technology Officer
The PowerTech Group
19426 68th Ave. S
Seattle, WA 98032
(253) 872-7788 ext. 302
john.earl@xxxxxxxxxxxxx
www.powertech.com 
 

 
This email message and any attachments are intended only for the use of
the intended recipients and may contain information that is privileged
and confidential. If you are not the intended recipient, any
dissemination, distribution, or copying is strictly prohibited. If you
received this email message in error, please immediately notify the
sender by replying to this email message, or by telephone, and delete
the message from your email system.
--

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of
> Doug_McLauchlan@xxxxxxxxxx
> Sent: Friday, November 04, 2005 5:21 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Library List used by FTP job
> 
> I would agree that changing QDFTJOBD is something to
> avoid.
> 
> In this case I have modified the code in my trigger
> program to change the
> library list (to that specified in INLIBL) only for the
> job that fired the
> trigger. This change will only happen when the FTP job is
> writing to the
> table that has the trigger and should not affect any other
> FTP
> connections.
> 
> Am I right in thinking that the FTP job started for the
> connection will
> end after the connection is complete ? It appears that way
> from my recent
> tests, but I'm no expert on this.
> 
> 
> Doug McLauchlan
> Planar Systems, Inc.
> 
> 
> 
> 
> 
> "John Earl" <john.earl@xxxxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 11/04/2005 05:05 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-
> l@xxxxxxxxxxxx>
> 
> 
> To
> "Midrange Systems Technical Discussion" <midrange-
> l@xxxxxxxxxxxx>
> cc
> 
> Subject
> RE: Library List used by FTP job
> 
> 
> 
> 
> 
> 
> Doug,
> 
> INLLIBL list is a snap, initially, but it is going to
> cause you (and
> potentially others) lots of grief in the long run.
> 
> An FTP server program by default is re-used 200 times by
> up to 200
> different users.  The chances of all 200 uses needing the
> same library
> list for each ftp is pretty slim, and the chances of you
> stepping on
> someone else is pretty high.
> 
> If you were to change QTCP's JOBD (QDFTJOBD) to include
> your library,
> you will be affecting hundreds of IBM initiated jobs on
> the system.  Now
> all of these jobs (and all of their user's) are going to
> have to have at
> least *USE authority to your application library in order
> to even start.
> If anyone ever secures your library, or accidentally
> deletes it, or
> takes an exclusive lock out on it during a Save operation,
> you break all
> kinds of system stuff and potentially prevent access to
> the system
> (because QDFTJOBD is QSECOFR's JOBD too).
> 
> You're far better off to write a little code to manage the
> library list
> on your own.  If you need some tips, I'd be happy to have
> someone send
> you some code snippets.
> 
> (Not that this scares me - we've already shielded
> ourselves from these
> kinds of things - it's just the right thing to do).
> 
> jte
> 
> 
> --
> John Earl | Chief Technology Officer
> The PowerTech Group
> 19426 68th Ave. S
> Seattle, WA 98032
> (253) 872-7788 ext. 302
> john.earl@xxxxxxxxxxxxx
> www.powertech.com
> 
> 
> 
> This email message and any attachments are intended only
> for the use of
> the intended recipients and may contain information that
> is privileged
> and confidential. If you are not the intended recipient,
> any
> dissemination, distribution, or copying is strictly
> prohibited. If you
> received this email message in error, please immediately
> notify the
> sender by replying to this email message, or by telephone,
> and delete
> the message from your email system.
> --
> 
> > -----Original Message-----
> > From: midrange-l-
> > bounces+john.earl=powertech.com@xxxxxxxxxxxx
> > [mailto:midrange-l-
> > bounces+john.earl=powertech.com@xxxxxxxxxxxx] On Behalf
> Of
> > Doug_McLauchlan@xxxxxxxxxx
> > Sent: Thursday, November 03, 2005 3:18 PM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: Library List used by FTP job
> >
> > Thanks for this.
> >
> > It looks from the replies here and elsewhere that there
> is
> > no fix for this
> > problem, only many different workarounds !
> >
> > I have used this idea since it involved the least amount
> > of coding and is
> > adaptable to use in other situations - we do have BPCS
> > here, so using
> > INLIBL to set the library list is a snap.
> >
> > Thanks again.
> >
> >
> > Doug McLauchlan
> > Planar Systems, Inc.
> >
> >
> >
> >
> > rob@xxxxxxxxx
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > 11/03/2005 08:00 AM
> > Please respond to
> > Midrange Systems Technical Discussion <midrange-
> > l@xxxxxxxxxxxx>
> >
> >
> > To
> > Midrange Systems Technical Discussion <midrange-
> > l@xxxxxxxxxxxx>
> > cc
> >
> > Subject
> > Re: Library List used by FTP job
> >
> >
> >
> >
> >
> >
> > Modify the trigger to set up it's library list.
> > Traditionally that is
> > done by analyzing the trigger buffer to determine what
> > library the file is
> >
> > in that is triggered.  Then adding that library to the
> > library list.  Some
> >
> > applications will have a file or dataarea in that file
> > library that
> > contains other libraries to add (like BPCS INLIBL data
> > area).  You may
> > need to add these also if the trigger is dependent on
> it.
> >
> > Many analysts design triggers "assuming" that they'll
> only
> > be called from
> > existing 5250 programs that have the library list
> already
> > set up.  This is
> >
> > called stepping on your winkie.
> >
> > Rob Berendt
> > --
> > Group Dekko Services, LLC
> > Dept 01.073
> > PO Box 2000
> > Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >
> >
> >
> >
> >
> > Doug_McLauchlan@xxxxxxxxxx
> > Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
> > 11/02/2005 06:59 PM
> > Please respond to
> > Midrange Systems Technical Discussion <midrange-
> > l@xxxxxxxxxxxx>
> >
> >
> > To
> > midrange-l@xxxxxxxxxxxx
> > cc
> >
> > Fax to
> >
> > 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.
> >
> __________________________________________________________
> > ____________
> > --
> > This is the Midrange Systems Technical Discussion
> > (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> > http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion
> > (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> > http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> >
> __________________________________________________________
> > ____________
> > 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.
> >
> __________________________________________________________
> > ____________
> >
> >
> >
> >
> __________________________________________________________
> > ____________
> > 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.
> >
> __________________________________________________________
> > ____________
> > --
> > This is the Midrange Systems Technical Discussion
> > (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> > http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/midrange-l.
> >
> 
> 
> --
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> __________________________________________________________
> ____________
> 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.
> __________________________________________________________
> ____________
> 
> 
> 
> __________________________________________________________
> ____________
> 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.
> __________________________________________________________
> ____________
> --
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.