Return-Path: Delivered-To: apmail-db-general-archive@www.apache.org Received: (qmail 77439 invoked from network); 26 Oct 2007 11:24:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Oct 2007 11:24:28 -0000 Received: (qmail 90160 invoked by uid 500); 26 Oct 2007 11:24:15 -0000 Delivered-To: apmail-db-general-archive@db.apache.org Received: (qmail 90114 invoked by uid 500); 26 Oct 2007 11:24:15 -0000 Mailing-List: contact general-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: general@db.apache.org List-Id: Delivered-To: mailing list general@db.apache.org Received: (qmail 90102 invoked by uid 99); 26 Oct 2007 11:24:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2007 04:24:15 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of soumensaha@gmail.com designates 64.233.162.227 as permitted sender) Received: from [64.233.162.227] (HELO nz-out-0506.google.com) (64.233.162.227) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2007 11:24:18 +0000 Received: by nz-out-0506.google.com with SMTP id m7so681334nzf for ; Fri, 26 Oct 2007 04:23:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=DF2OQGrhJrWNxswAhX2Slt83UKb451Ucg12aUtLGtTQ=; b=OElPfpcTFfwYifmIGozgqG9BPNZtV7wlL4pdVjjsFcfgKuXNb+ZNckRC11t539t14RZZs/oJLKZZEOQcNfKLu0hyGb52ZrnA5X0NpOyvYAjLkC7pFOAT68cVBoVi2dBiem9D7uAungx+ndEDT6GwOCMKFBDWlB/B7KtV9B8GtXM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=TAjl8H4FQ9eNbPfdOTXa1fSx8X2Z0Lj46yCTl914fodgvhH1Ds0ktYf7mRbo12+DdSX3CciVrGOhkoZPy3AlGuEXpe6FhdDC3ZxpV4eS0saounLvFtNS94KiOWozMn4n/exVmcqcA1nMPa2hEaknx7BBSAkDYNXoMYtD8BfdqfY= Received: by 10.142.215.5 with SMTP id n5mr794389wfg.1193397837066; Fri, 26 Oct 2007 04:23:57 -0700 (PDT) Received: by 10.142.125.15 with HTTP; Fri, 26 Oct 2007 04:23:57 -0700 (PDT) Message-ID: <1eb85fd50710260423p2cefa316nd0b71836522c54b7@mail.gmail.com> Date: Fri, 26 Oct 2007 07:23:57 -0400 From: "Soumen Saha" To: general@db.apache.org Subject: Re: Default table In-Reply-To: <47214C8C.7030806@amberpoint.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4482_5827780.1193397837099" References: <1eb85fd50710251853u6d61e905lcb4715a3ad5f931d@mail.gmail.com> <47214C8C.7030806@amberpoint.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_4482_5827780.1193397837099 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks a lot... This is really helpful.. Regards, Soumen On 10/25/07, Bryan Pendleton wrote: > > > What is the default table name in Derby? I want to display some fixed > > data using SQL like > > select '10' as digit > > It runs in SQL server. In Oracle I can write in this way > > select '10' as digit from dual > > but here none of these are working. How can I solve this problem? > > Here's two ways: > > 1) Use the "VALUES" statement: > > values cast ('10' as int); > > 2) Use SYSIBM.SYSDUMMY1 in place of DUAL: > > select cast('10' as int) from sysibm.sysdummy1; > > thanks, > > bryan > ------=_Part_4482_5827780.1193397837099 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks a lot... This is really helpful..

Regards,
Soumen

On 10/25/07, Bryan Pendleton <bpendleton@amberpoint.com > wrote:
> What is the default table name in Derby? I want to display some fixed
> data using SQL like
> select '10' as digit
> It runs in SQL server. In Oracle I can write in this way
> select '10' as digit from dual
> but here none of these are working. How can I solve this problem?

Here's two ways:

1) Use the "VALUES" statement:

  values cast ('10' as int);

2) Use SYSIBM.SYSDUMMY1 in place of DUAL:

  select cast('10' as int) from sysibm.sysdummy1 ;

thanks,

bryan

------=_Part_4482_5827780.1193397837099--