RE: SQL 462 Error On QSYS2.OBJECT_STATISTICS

Is it just a warning because the qtemp table does not exist at compile time? I recently did something with a temp table from SQLRPGLE and seems like I saw a warning but don't remember what it was. Does the program compile successfully and if so, does it execute properly.

Scott Mildenberger | Software Developer | Washington Companies IT Services | 101 International Drive | Missoula, MT | Office: 406-523-1536 | www.washingtoncompanies.com

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert Wenzel
Sent: Wednesday, November 18, 2020 8:15 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: SQL 462 Error On QSYS2.OBJECT_STATISTICS

Can anyone tell me how to identify the object, or objects, to which I am getting a "NOT AUTHORIZED TO OBJECT" message text from my SQL 462 warning in my SQLRPGLE program?

create table qtemp.objstats as
(select current server as server,
objlib as schema,
objname as object,
objtype as objecttype,
coalesce(date(Last_used_timestamp),'0001-01-01') as LastUsedDate
from table (QSYS2.OBJECT_STATISTICS('ARCUSTP','*ALL')) as X) with data ;;

I have run this table function with two different user profiles; one user profile has all object authority and one (mine) does not. They return the exact same list of objects so why am I getting warning 462?

FYI, I get the same warning when I clear the QTEMP table and use an INSERT statement instead and, also, when I use a simple SELECT.

Thanks, in advance, for your advice.

--