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?
精彩评论