In this blog post, let’s learn about the error message “3405 A logical partition name cannot be specified in the LOCATION clause of the CREATE statement of this object.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3405 A logical partition name cannot be specified in the LOCATION clause of the CREATE statement of this object.
Reason for the Error
You cannot specify the logical partition name in the LOCATION clause of the create statement of catalog, procedure, view, and materialized view object types.
Solution
Remove the logical partition name syntax from the LOCATION clause and resubmit
