HPE NonStop SQL/MX Error – 1144 A quoted string was expected in first key clause for column column-name on table table-name, but the value detected is (first-key-string).

In this blog post, let’s learn about the error message “1144 A quoted string was expected in first key clause for column column-name on table table-name, but the value detected is (first-key-string).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1144 A quoted string was expected in first key clause for column column-name on table table-name, but the value detected is (first-key-string).

Reason for the Error

In a CREATE TABLE statement, a value specified as first key is not a quoted string, but the type of the column for which this value is specified is one of the character data types.

Solution

Correct the value first-key-string to be a type that is compatible with the type of column column-name and resubmit