SQLJ: Difference between revisions

Content deleted Content added
Added similar project part with one project which helped me
No edit summary
Line 5:
Some advantages of SQLJ over JDBC include:
* SQLJ commands tend to be shorter than equivalent JDBC programs.
* SQL syntax can be checked at compile time. The returned query results can also be checked strictly.
* Preprocessor might generate static SQL which performs better than dynamic SQL because query plan is created on program compile time, stored in database and reused at runtime. Static SQL can guarantee worst case reply time and access plan stability. IBM DB2 supports static SQL use in SQLJ programs.