From dev-return-18186-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed Dec 29 20:15:32 2010 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 32559 invoked from network); 29 Dec 2010 20:15:31 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 29 Dec 2010 20:15:31 -0000 Received: (qmail 74664 invoked by uid 500); 29 Dec 2010 20:15:31 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 74622 invoked by uid 500); 29 Dec 2010 20:15:30 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 74614 invoked by uid 99); 29 Dec 2010 20:15:30 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Dec 2010 20:15:30 +0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Dec 2010 20:15:24 +0000 Received: from jim.nabble.com ([192.168.236.80]) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1PY2QJ-000293-HK for dev@openjpa.apache.org; Wed, 29 Dec 2010 12:15:03 -0800 Date: Wed, 29 Dec 2010 12:15:03 -0800 (PST) From: ashish22 To: dev@openjpa.apache.org Message-ID: <1293653703507-5875426.post@n2.nabble.com> Subject: OpenJPA DB2 and the QUERYNO Clause MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.