Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 79624 invoked from network); 18 Apr 2010 13:07:43 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 18 Apr 2010 13:07:43 -0000 Received: (qmail 9903 invoked by uid 500); 18 Apr 2010 13:07:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 9871 invoked by uid 500); 18 Apr 2010 13:07:43 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 9864 invoked by uid 99); 18 Apr 2010 13:07:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Apr 2010 13:07:43 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.6.21] (HELO gmp-eb-inf-1.sun.com) (192.18.6.21) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Apr 2010 13:07:35 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-1-fe1.eu.sun.com [192.18.6.7] (may be forged)) by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id o3ID7Djm023405 for ; Sun, 18 Apr 2010 13:07:13 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII; format=flowed Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0L1200400PQY5900@fe-emea-10.sun.com> for derby-dev@db.apache.org; Sun, 18 Apr 2010 14:06:54 +0100 (BST) Received: from [192.168.0.195] ([unknown] [84.215.174.92]) by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0L1200BMKPREKZ50@fe-emea-10.sun.com> for derby-dev@db.apache.org; Sun, 18 Apr 2010 14:06:54 +0100 (BST) Date: Sun, 18 Apr 2010 15:06:50 +0200 From: Kristian Waagan Subject: Re: Querying XPLAIN style tables through JDBC In-reply-to: Sender: Kristian.Waagan@Sun.COM To: derby-dev@db.apache.org Message-id: <4BCB03EA.1020906@Sun.COM> References: User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.9.1.8) Gecko/20100329 Lightning/1.0b1 Thunderbird/3.0.3 X-Virus-Checked: Checked by ClamAV on apache.org On 18.04.10 14:50, Thiwanka Somasiri wrote: > > It is possible to query XPLAIN style tables in ij.For example, > > call syscs_util.syscs_set_xplain_schema('MY_STATS'); > > How can I do this in a Java Program in order to set the explain schema? Hi Thiwanka, I think you can use a CallableStatement in JDBC, see [1]. Regards, -- Kristian [1] http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html > > > -- > > Regards > > A.S.Thiwanka Somasiri > Department of Computer Science and Engineering, > University of Moratuwa, > Sri Lanka. > > Skype : executionerwild > MSN : thiwas@ymail.com