In this blog post, let’s learn about the error message “3220 SHOWDDL failed for object object-name because an SQL/MP display option was used on a SQL/MX object.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3220 SHOWDDL failed for object object-name because an SQL/MP display option was used on a SQL/MX object.
Reason for the Error
SHOWDDL was given the SQL/MP display option with an SQL/MX table given as an argument.
Solution
Reissue the command without the SQL/MP display option or specify an SQL/MP object
