Situations or coding practices that might cause problems when your non-pureQuery API application runs SQL statements statically

Your non-pureQuery API application might not work well with static SQL if it contains code that leads to any of the following situations.
Use the pureQuery Log utility when you are capturing SQL. The messages that this utility logs can help you determine the level of your application's compatibility with static SQL.

When capturing SQL statements running against DB2® databases, the capture process logs changes to DB2 special registers. Changes to special registers that are commonly used and that might affect data returned by the SQL statement are also captured in the pureQueryXML files. For information on how pureQuery Runtime tracks special register changes see the related links.


Feedback