In this blog post, let’s learn about the error message “2108 Statement was compiled as if query plan caching were off.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2108 Statement was compiled as if query plan caching were off.
Reason for the Error
The SQL/MX compiler attempted to compile this query with query caching on but failed. It then successfully compiled this query with caching turned off.
Solution
This is an informational message. To prevent this warning, turn off query caching before query preparation