Given that SQLJ supports only static SQL, can I intermix SQLJ and JDBC statements in my source code so that I can use dynamic SQL in the same application?

Yes--you can have JDBC statements in your SQLJ source code. Furthermore, features are built into SQLJ to allow convenient interoperability between SQLJ iterators and JDBC result sets and between SQLJ connections and JDBC connections. If you are using SQLJ version 9.0.1 or later, you got the best of both worlds: you can embed dynamic SQL code into SQLJ statements using the syntax ":{ java String expression }" - see sqlj/demo/DynamicDemo.

Sqlj in your SQLJ distribution for more details. The remainder discusses how to use the general SQLJ-JDBC interaoperability. To create a JDBC result set rs from a SQLJ iterator iter, use the getResultSet() method of your iterator instance: ResultSet rs = iter.getResultSet(); To create a SQLJ iterator iter from a JDBC result set rs, use a SQLJ cast statement: #sql iter = { CAST : rs }; To create a JDBC connection instance conn from a SQLJ connection context instance ctx (inheriting the same underlying connection to the database), use the getConnection() ... more.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions