Can someone explain me the importance of "Dynamic query mode" check box while creating the Package? Thanks
the package will use dynamic query mode.
Quote from: cielo on 18 Sep 2019 05:47:44 PM
Can someone explain me the importance of "Dynamic query mode" check box while creating the Package? Thanks
Hi,
You see this option if your FM model uses Compatible Query Mode. It allows you to choose whether packages you publish use Compatible Query Mode or Dynamic Query Mode. CQM uses the old legacy native connection types and is limited to 32-bit, whereas DQM uses more modern JDBC access and is 64-bit. Just because a package works using CQM, you should not assume it will work, or work in the same way in DQM. Moving from one to the other is a migration rather than an upgrade - DQM is a lot more strict in what it enforces and how it plans queries, so worst case some reports might break, and others might not return the same results.
Cheers!
MF.
Thanks a lot ,MF! got it.