In this blog post, let’s learn about the error message “3206 The name for an object of this type must be fully qualified, or set NAMETYPE ANSI.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3206 The name for an object of this type must be fully qualified, or set NAMETYPE ANSI.
Reason for the Error
In the CREATE PROCEDURE statement, you specified a partially qualified name when NAMETYPE was not set to ANSI.
Solution
Set NAMETYPE ANSI or fully qualify the name