HPE NonStop SQL/MX Error – 4129 An IF statement should have the same set of output host variables on both sides of IF THEN statement list and the ELSE statement list.

In this blog post, let’s learn about the error message “4129 An IF statement should have the same set of output host variables on both sides of IF THEN statement list and the ELSE statement list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4129 An IF statement should have the same set of output host variables on both sides of IF THEN statement list and the ELSE statement list.

Reason for the Error

You specified an IF statement that does not have the same set of output host variables on both sides of its IF THEN statement list and its ELSE statement list.

Solution

Correct the syntax and resubmit