Hello,

We have a requirments from our  DBAs to add the QUERYNO clause in our
queries. We are using OpenJPA 1.2.1 and the underlying database  is DB2.

The current queries that go from the application server to the database via
the JPA are like

Select X from Y where A = B;

The DBAs want it to be

Select X from Y where A = B  QUERYNO 2223456;

We played around with the setHint but we are not able to add the QUERYNO
clause as required.

Any help would be appriciated


Thanks
Ashish








-- 
View this message in context: 
http://openjpa.208410.n2.nabble.com/OpenJPA-DB2-and-the-QUERYNO-Clause-tp5875426p5875426.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

Reply via email to