Re: QUSER not authorized when calling sp

Forgive me if I am misunderstanding but I think this is the situation:

On the prod machine you are calling the SP, and the SP is on the dev
machine.

The call on the prod machine uses three part naming to the SP.

The SP on the dev machine if found and starts executing on the dev machine.

The SP fails when it tries to do an insert into a table on the dev machine.

Just prior to the failure the SP succeeds in deleting a record from the
table on the dev machine.

The record to be inserted is the result set of a select from the prod
machine, the select using three part naming.

So, suggestion:

Can you make a version of the SP which runs just the select logic
without an insert clause and see if that works?

If it does, then apparently a combination of an insert to a local
database using data from a remote database either has a bug, or is not
supported.

Sam


On 3/21/2022 9:35 AM, Robert Rogerson wrote:

Hi Jack,
I am using three part naming in the INSERT statement.
When I call the stored procedure (which exists on the dev machine) I use
three part naming on the production machine.
CALL devmachine.devlibrary.INSERT_REC;

Then in the stored procedure I insert data into a table on the dev

machine

with data from the production machine using three part naming.

Also I should add, right before I attempt to insert the new record I

delete

the old record from the same table I am about to insert into. This works
and I have confirmed the delete actually happens.

Thanks,

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com