I have a CL program that does an OVRDBF on an existing table in my libary to Qtemp, with overscope set to the activation group and then calls an RPG procedure which is bound to the CL. In debug mode, I can see the overrides are still valid and the activation group is active.
I want to do an insert into a table of one record/one field. When the SQL Insert attempts to execute it throws an SQL 42704 (table undefined) as though it cannot find the Qtemp table.
Obviously I am doing something wrong here. Do I need to specify the table as *USROPN and actually open the table in the RPG for the override to be in effect?
I want to do an insert into a table of one record/one field. When the SQL Insert attempts to execute it throws an SQL 42704 (table undefined) as though it cannot find the Qtemp table.
Obviously I am doing something wrong here. Do I need to specify the table as *USROPN and actually open the table in the RPG for the override to be in effect?
Comment