In this blog post, let’s learn about the error message “393” in Hydra and the description of the error.
Error Message
393
Error Details
The named view cannot be dropped as it does not exist. To see names of existing views, query systables as follows:
SELECT tabname FROM systables WHERE tabtype = ‘V’
The where clause contains an outer cartesian product.
This query requests an outer join, but either the WHERE clause is missing in the query, or the conditions in the WHERE clause cause every row of the subordinate table to be selected for every row of the dominant table, resulting in a very large output.
Review the query, and check that at least one condition in the WHERE clause relates each dominant-subordinate pair of tables in the query.