Too Many Open Files (was Re: The CLOSE command)

[Jeff Harrison]

--- Jeff Harrison <jeffaharrison at yahoo.com> wrote:

> --- Kenneth Brody <kenbrody at bestweb.net> wrote:
> 
> > Quoting Jay R. Ashworth (Thu, 16 Feb 2006 12:05:48
> > -0500):
> > 
> > > On Thu, Feb 16, 2006 at 11:10:09AM -0500, Howard
> > Wolowitz wrote:
> > > > Subject: The CLOSE command
> > > >
> > > > If I do lookups to multiple files using the
> same
> > lookup name (a common
> > > > practice at Aljex) and then I issue a CLOSE
> for
> > that lookup name -
> > > > what happens?
> > [...]
> > > I would assume that when you re-use the lookup
> tag
> > for a new file, that
> > > the old one's handle is automatically closed,
> but
> > I might be wrong; it
> > > may just be that the tag->file association is
> > broken.
> > 
> > The latter.
> > 
> 
> So I guess that in order to prevent these stranded
> files one would need to make sure that a close is
> executed before the tag is associated with a new
> file,
> or else re-execute the lookup that you wish to close
> prior to issuing another close.
> 

There is a company that I used to work for that for
years has been getting these "Too many open files"
errors from time to time.  In fact certain processes
would get them all the time.  I could never figure out
why before, but it seems to make sense now.  The
original programmer there made extensive use of
chained and called processing tables.  There were many
lookups and re-use of lookup aliases.

If anyone else is getting this error I would suggest
that they be on the lookout for this "feature"

Perhaps a solution for this that fptech could supply
would be a PFCLOSEONCHAIN and a PFCLOSEONCALL
environment variable, and perhaps a CLOSEALL command. 
The CLOSEALL command would close all open files (via
lookups) if called without any arguments.  With
arguments, it would close all files associated with
the entire filepro file(s) specified.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports.



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com