In this blog post, let’s learn about the error message “3150 Duplicate WITH HEADING phrases were specified in LIKE clause in CREATE TABLE statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3150 Duplicate WITH HEADING phrases were specified in LIKE clause in CREATE TABLE statement.
Reason for the Error
The WITH HEADINGS phrase appears multiple times within the LIKE clause of the CREATE TABLE statement, which is not supported.
Solution
Remove the duplicate WITH HEADINGS phrases