HPE NonStop SQL/MX Error – 4085 File organization name1 of object name2 is not supported.

In this blog post, let’s learn about the error message “4085 File organization name1 of object name2 is not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4085 File organization name1 of object name2 is not supported.

Reason for the Error

You specified an invalid file organization name1 (for example, “R” for Relative) for table name2.

Solution

Correct the syntax and resubmit