HPE NonStop SQL/MX Error – 3404 Character set name, to which SQL_TEXT is aliased, is not allowed for a SQL module.

In this blog post, let’s learn about the error message “3404 Character set name, to which SQL_TEXT is aliased, is not allowed for a SQL module.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3404 Character set name, to which SQL_TEXT is aliased, is not allowed for a SQL module.

Reason for the Error

You specified SQL_TEXT as the module character name set. SQL_TEXT is synonymous with UCS2, which is not supported.

Solution

Replace SQL_TEXT with ISO88591 and resubmit