开发者

Can AS/400 Database Tables Be Hidden?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜