In this blog post, let’s learn about the error message “3402 The format of the value hexadecimal string literal is not valid.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3402 The format of the value hexadecimal string literal is not valid.
Reason for the Error
You either used illegal hexadecimal digits, supplied an odd number of hexadecimal digits, or misplaced space separators.
Solution
Specify the string in the correct hexadecimal format and resubmit