-198   THE OPERAND OF THE PREPARE OR EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY

Explanation

The operand (host variable or string constant) that was the object of the PREPARE or EXECUTE IMMEDIATE statement either contained all blanks or was an empty string. A DBRM built in Version 2 Release 3 cannot be used on a Version 2 Release 2 system if the distributive functions were used. If this error appears on Version 2 Release 2 and the DBRM was built on Version 2 Release 3, then the program needs to be precompiled again to correct the problem.

System action

The statement cannot be processed.

Programmer response

Correct the logic of the application program to ensure that a valid SQL statement is provided in the operand of the PREPARE or EXECUTE IMMEDIATE statement before that statement is executed.

SQLSTATE

42617