Sponsored Links
Sponsored Link

sponsored links

Collapse

Announcement

Collapse
No announcement yet.

Best Practice for Dymanic SQL statement

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Best Practice for Dymanic SQL statement

    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

sponsored links

Collapse

Working...
X