Dynamic Query mode

[cielo]

Can someone explain me the importance of "Dynamic query mode" check box while creating the Package? Thanks

[Francis aka khayman]

the package will use dynamic query mode.

[MFGF]

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.

[cielo]

Thanks a lot ,MF! got it.