开发者

Can AS/400 Database Tables Be Hidden?

开发者 https://www.devze.com 2023-01-07 21:31 出处:网络
I was trying to delete a record from a table in AS/400 database. I got an error message saying that there is a referential i开发者_开发百科ntegrity to another table XYZ in the same Schema ABC.

I was trying to delete a record from a table in AS/400 database. I got an error message saying that there is a referential i开发者_开发百科ntegrity to another table XYZ in the same Schema ABC.

To my wonder, that table was not in the list of the tables shown by my DbVisualizer database client.

Then I decided to do a select on that table (ABC.XYZ) - but I got the records back. Thinking that it might be a client problem, I used another Client (AS/400 Operations Navigator) - I had the same results: table not on the list, but got the results back when I did a SELECT * FROM ABC.XYZ

My questions is, can the AS/400 tables be hidden in such a manner?

(Please note that the table was not even in the views/system table/Alias/Materialized Query Table)


Tables can be "hidden" via authorities on the object. Do you have *ALLOBJ authority?

0

精彩评论

暂无评论...
验证码 换一张
取 消