HPE NonStop SQL/MX Error – 1038 Not all user catalogs have been dropped from the system.

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