Re: RNX1011 Error

Okay, I found the solution.  I apologize for dumping an essay on the
group, but I was desperate.  The problem was, on the CHAIN operation,
I was using the file entry name (which is allowed, and per the IBM
manuals, works).  At times, it seems that, at least on my box, using
the file name doesn't always work with CHAIN, and it seems, per the
INFDS, to be looking for a blank format name (or perhaps this field in
the INFDS is just blank because I used the filename on the CHAIN).  So
I changed the CHAIN op to the format name, and voila.  This is a
single-format PF, by the way.


On Fri, 21 Jan 2005 15:41:04 -0800, Tony Carolla <carolla@xxxxxxxxx> wrote:
> I have created a module in a service program, that calculates the
> dollar value of a loss from a log file record.  The module
> occasionally needs to open a file (MEMBR), and chain to a record in
> that file.
> 
> Because we have multiple companies, the file opened could be in one of
> 60 or so libraries.  All copies of this file have the same name, same
> meber name, and the same format identifier.  I have set up the F spec
> with an EXTFILE variable, and when I need to open the file, I close it
> if open, resolve the EXTFILE variable, open the file, then chain.
> Done it thousands of times, no problem.
> 
> And the service program works beautifully, when called from another
> RPG program.  I have set up an SQL function for our 'reporting' users,
> and this function calls the module and returns the cost to the SQL
> view.  And this works marvelously.  Until it has to use one particular
> copy of the MEMBR file.  Just one of our copies, and it is the same
> copy that errors out every time.  When the view tries to call the
> service program, it errors with the RNX1011 error, on the statement
> number in the service program where the CHAIN op is at.  I can use an
> RPG program and resolve costs for all records that relate to the same
> copy of the MEMBR file, but when I try to use the module from the SQL
> function, the certain copy causes the error.
> 
> I have verified that this copy is the same format name, same format,
> same everything.  How can I debug this error further?  I have used
> debugging, and the file that is open before the CHAIN is the correct
> file, the fields used to CHAIN are valid, and nothing looks wrong, but
> the CHAIN fails.  HELP!
> 
> 
> --
> "Enter any 11-digit prime number to continue..."
> 


-- 
"Enter any 11-digit prime number to continue..."