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 integrity 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)