Hi, can you help me to know how is the best practices to create dynamics SQL in DB2 for i, I have v7r1. Our application is a web app and we have many dynamics procedures. This is one example how the where condition is constructed.
SET WHERE_DYNAMIC = WHERE_DYNAMIC || N' SHORDER = ' || ORDERNUMBER
I want to avoid the engine needs to parse each time and I want the execution plan can be reused and with this condition i know that's impossible. Can you help me please
SET WHERE_DYNAMIC = WHERE_DYNAMIC || N' SHORDER = ' || ORDERNUMBER
I want to avoid the engine needs to parse each time and I want the execution plan can be reused and with this condition i know that's impossible. Can you help me please