static vs dynamic sql

[tarik el berrak]

Hi all,

What's the difference between static and dynamic sql ? which must be used and why ?

Thanks

[Jeanne Boyarsky]

Tarik,
IBM has a good comparison. From a Java perspective, it is good to use PreparedStatements to handle your binding variables so you don't have to worry about things like date formats and SQL injection.