In this blog post, let’s learn about the error message “1038 Not all user catalogs have been dropped from the system.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1038 Not all user catalogs have been dropped from the system.
Reason for the Error
You attempted to drop SQL while one or more user-created catalogs existed.
Solution
Drop all user-created catalogs before dropping SQL
