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
