HPE NonStop SQL/MX Error – 3151 Duplicate WITH HORIZONTAL PARTITIONS phrases were specified in LIKE clause in CREATE TABLE statement.

Data 22 Views 1 Min Read

In this blog post, let’s learn about the error message “3151 Duplicate WITH HORIZONTAL PARTITIONS 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

3151 Duplicate WITH HORIZONTAL PARTITIONS phrases were specified in LIKE clause in CREATE TABLE statement.

Reason for the Error

The WITH HORIZONTAL PARTITIONS phrase appears multiple times within the LIKE clause of the CREATE TABLE statement, which is not supported.

Solution

Remove the duplicate WITH HORIZONTAL PARTITIONS phrases

Tags: